Powershell replace string from array inside foreach loop

Question

I have a CSV file containing products, this CSV file has a column for brands and a column for categories. I'm trying to run a foreach loop to remove the brand names from the categories column.

$products = import-csv X:\products.csv
$brands = $products.Brand | sort | select -unique

foreach ($item in $products) {
  $item.categories = $item.categories.Replace("Coming Soon","")
  $item.categories = $item.categories.Replace($brands,"")
}

The "Coming Soon" gets removed, but all the brand names that are containd in $brands still remain.

Where am I going wrong?

Mathias R. Jessen · Accepted Answer · 2020-05-27 21:41:45Z

1

Right now you're attempting to remove all the brand names from each categories property.

Reference $item.Brand inside the foreach loop to get the corresponding one:

foreach($item in $products){
  $item.categories = $item.categories.Replace("Coming Soon","")
  $item.categories = $item.categories.Replace($item.Brand,"")
}

answered May 27, 2020 at 21:41

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Embercide Over a year ago

Awesome, such a simple thing that I've overcomplicated! Just so I'm clear on what I was doing wrong - it wasn't working because it was looking for 200+ brand names in a single property?

Collectives™ on Stack Overflow

Powershell replace string from array inside foreach loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related