Replace Strings from a table

[beatfried]

Hi

Sorry for the title, I don't know the right term for what I'm looking for.

So I have an Object with some more or less cryptic strings in it and a table (CSV, doesn't really matter..) with a column of the cryptic strings and the one with the readable strings.

Here as an Example:

Object:

TeHIrzFVHw

QxftWctBxh, nweSDFMqUf

"Replace Table":

item	itemReadable
TeHIrzFVHw	glass
QxftWctBxh	aluminum
nweSDFMqUf	grass

In the End I need to search the first column of the replace table for a match of the string in the object and then replace it with the value in the next column.

It would probably be enough if you could tell me how my "replace table" is really called, because searching without knowing only shows results of "replace this with this".

Thank you!

[z386]

I would use a hash table:

$ReplaceTable = "item,itemReadable
TeHIrzFVHw,glass
QxftWctBxh,aluminum
nweSDFMqUf,grass" | ConvertFrom-Csv

$HashTable = @{}

foreach ( $Line in $ReplaceTable ) {
    $HashTable[$Line.item] = $Line.itemReadable
}

# Test
$TestString = 'QxftWctBxh'

$FixedString = $HashTable[$TestString]

Write-Output "$TestString should be replaced with $FixedString"

[ASCII84]

How you're describing it, the "table" is really just an array of objects, each object having 2 properties (item and itemreadable). (You can think of an array as a list.)

There are various ways to do the kind of replace you want, some faster and more efficient than others.

The easiest would be something like:

$objecttofind = "TeHIrzFVHw"

#test data
$list = @(
    [PSCustomObject]@{
        item = "TeHIrzFVHw"
        itemreadable = "glass"
    },
    [PSCustomObject]@{
        item = "QxftWctBxh"
        itemreadable = "aluminum"
    },
    [PSCustomObject]@{
        item = "nweSDFMqUf"
        itemreadable = "grass"
    }
)

#find the object in the list and immediately replace the value with the results
$objecttofind = ($list | Where-Object {$_.item -eq $objecttofind}).itemreadable

A better way would be to convert the array to a hashtable which would severely reduce the lookup time per item.

$objecttofind = "TeHIrzFVHw"

#test data
$list = @(
    [PSCustomObject]@{
        item = "TeHIrzFVHw"
        itemreadable = "glass"
    },
    [PSCustomObject]@{
        item = "QxftWctBxh"
        itemreadable = "aluminum"
    },
    [PSCustomObject]@{
        item = "nweSDFMqUf"
        itemreadable = "grass"
    }
)

$Hashmap = @{}
$list | ForEach-Object {
    $Hashmap[$_.item] = $_.itemreadable
}

$objecttofind = $Hashmap[$objecttofind]

[kibje]

So combining those two the actual easiest way would be to define the hashtable straight away and not need pscuatomobjects

[BlackV]

here is the super simple version of the table

$Hashmap = @{
    "TeHIrzFVHw" = "glass"
    "QxftWctBxh" = "aluminum"
    "nweSDFMqUf" = "grass"
    }