PowerShell replace string from Csv file

Question

Csv file contents some thousands of rows and want to replace text within it.

MacBookPro*,*, with MacBookPro1*.*,

'*' is wildcard here. Text looks something like this

MacBookPro13,1,

This to be replaced with

MacBookPro,

I am not good at regex and need help.

Ranadip Dutta · Accepted Answer · 2017-11-28 07:35:51Z

1

You can directly do that in Powershell and can check in the CSV as well.

$string_var = 'MacBookPro*,*,'
$newstring_var=$string_var.Replace($string_var,'MacBookPro1*.*,')
$newstring_var

Let me know if you mean this.

answered Nov 28, 2017 at 7:35

Ranadip Dutta

9,5493 gold badges33 silver badges48 bronze badges

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

1 Comment

vikram athare Over a year ago

I am referring * as wildcard here. Sorry I was not clear. I am not able to figure out the regex to be used.

vikram athare · Accepted Answer · 2017-11-29 07:16:14Z

1

Able to resolve it ...

(Get-Content $ExportCsvFilePath) -replace 'MacBookPro(.*?),(.*?),','MacBookPro,' | Set-Content -Path $ExportCsvFilePath -Force

answered Nov 29, 2017 at 7:16

vikram athare

557 bronze badges

Comments

MattMoo · Accepted Answer · 2017-11-28 20:22:55Z

0

If you have multiple entries in the csv file this should replace all of them.

 $oldString = 'MacBookPro*,*,'
    $newString = 'MacBookPro1*.*,'
    $originalFilePath = "EnterPathToFileHere"
    $newFilePath = "EnterNewPathToFileHere"

    [io.file]::readalltext($originalFilePath).Replace($oldString, $newString) | Out-File $newFilePath -Encoding ascii –Force

answered Nov 28, 2017 at 20:22

MattMoo

1922 gold badges3 silver badges11 bronze badges

Collectives™ on Stack Overflow

PowerShell replace string from Csv file

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related