PowerShell string replace using RegEx

Question

This is rather a RegEx question than PS one. Here it goes:

I have a text file with data like below.

ABC Corp, x567 
xyz Corp, y567 
pqr Corp, m567 
ghysds ,inc, x567 
TRWsdsdsds ,org, y567 
TYUds ,ing, m567

How can I remove the first comma from line 4-6? (These lines have 2 commas. I need only the second one.) My plan is to insert this data into a table with 2 columns.

Thank you.

you could try this link: The second Answer is what you want. — Izaaz Yunus
– Izaaz Yunus, Commented Mar 14, 2014 at 1:02

kabb · Accepted Answer · 2014-03-14 01:16:10Z

2

You have to use look ahead to check to see if there is a second comma on the line.

,(?=.*,)

Use this to replace whatever it matches with an empty string. This will get rid of the first comma of lines that have two commas in them.

answered Mar 14, 2014 at 1:16

kabb

2,5222 gold badges20 silver badges26 bronze badges

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

2 Comments

dan-gph Over a year ago

This is the most elegant way.

RaviLobo Over a year ago

Thank you Kabb! Very nice answer. Unfortunately, being a newbie, I cannot promote your answer.

mjolinor · Accepted Answer · 2014-03-14 01:23:36Z

1

Here's mine:

$text = 
(@'
ABC Corp, x567
xyz Corp, y567 
pqr Corp, m567 
ghysds ,inc, x567 
TRWsdsdsds ,org, y567 
TYUds ,ing, m567
'@).split("`n")

$text -replace '(.+?),(.+?),(.+)','$1$2,$3'

ABC Corp, x567
xyz Corp, y567 
pqr Corp, m567 
ghysds inc, x567 
TRWsdsdsds org, y567 
TYUds ing, m567

answered Mar 14, 2014 at 1:23

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Comments

user189198 · Accepted Answer · 2014-03-14 01:17:20Z

0

You don't really need regular expressions for this, although it would work.

$StringList = @('abd,asdc,asdc', 'asdc,awegwe,aweg', 'asdfasdf,asdaweg');

foreach ($String in $StringList) {
    if ($String -match '.*,.*,') {
        $String.Remove($String.IndexOf(','), 1);
    }
    else {
        $String;
    }
}

answered Mar 14, 2014 at 1:17

user189198

Collectives™ on Stack Overflow

PowerShell string replace using RegEx

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related