|
Re: Modify CSV, add fields
On Aug 9, 6:56 am, Shay Levi <n...@addre.ss> wrote:
> Note that Import-Csv imports comma-separated value items, so replace
> ";" with a comma.
1# $a = @"
>> John;Smith;555-1212
>> Mike;Smith;555;1212
>> "@
>>
2# $a
John;Smith;555-1212
Mike;Smith;555;1212
3# $b = $a | foreach-object { $_ -replace(";",",") }
4# $b
John,Smith,555-1212
Mike,Smith,555,1212
|