Vista - Using .replace

I'm not sure why .replace doesn't work here.

PS C:\> gc 1.csv
USA ,20 <--a space after "USA"
USA,10
PS C:\> gc 1.csv|foreach{$_.replace('USA `,','USA`,')}
USA ,20 <--still a space after "USA"
USA,10
PS C:\> gc 1.csv|foreach{$_.replace('USA ','USA')}
USA,20 <--no space after "USA"
USA,10

I'm wanting to specify "USA[space]," as the text to replace though. I want
to make 99.99% sure I'm properly matching.

Will I have to resort to .NET regex?

>gc 1.csv|foreach{$_.replace('USA `,','USA`,')}

Its not matching because you have a backquote in the pattern. That
backquote isn't there in the file content...
Any particular reason why you're adding that?

- Marcel


"Marco Shaw" <marco@Znbnet.nb.ca> wrote in message
news:ON4fW1AGHHA.3468@TK2MSFTNGP04.phx.gbl...
> I'm not sure why .replace doesn't work here.
>
> PS C:\> gc 1.csv
> USA ,20 <--a space after "USA"
> USA,10
> PS C:\> gc 1.csv|foreach{$_.replace('USA `,','USA`,')}
> USA ,20 <--still a space after "USA"
> USA,10
> PS C:\> gc 1.csv|foreach{$_.replace('USA ','USA')}
> USA,20 <--no space after "USA"
> USA,10
>
> I'm wanting to specify "USA[space]," as the text to replace though. I
> want to make 99.99% sure I'm properly matching.
>
> Will I have to resort to .NET regex?
>

> >gc 1.csv|foreach{$_.replace('USA `,','USA`,')}
>
> Its not matching because you have a backquote in the pattern. That
> backquote isn't there in the file content...
> Any particular reason why you're adding that?

Don't I need to escape the ","?

> >gc 1.csv|foreach{$_.replace('USA `,','USA`,')}
>
> Its not matching because you have a backquote in the pattern. That
> backquote isn't there in the file content...
> Any particular reason why you're adding that?

Alright... I guess I didn't need to escape the ","...