Kiron

Sample data:

${c:data.csv}
Field1;Field2;Field3;Field4
John;PATTY;555-12345;NY
Homer;MAC CULLY;555-32147;NH
Selma;BOUVIER;555-12378;KS

Modifying it:

${c:data.csv} = ${c:data.csv} -replace ';', ','
$csv = import-csv data.csv
$csv | Add-Member NoteProperty Field0 ''
$csv | Add-Member NoteProperty Field5 ''
$csv | % {$_.field0 = "$($_.field1) $($_.field2)"; $_.field5 =
"$($_.field1[0])$($_.field2[0])"}
$csv | select (0..5 | % {"field$_"}) | export-csv data.csv -NoType


Modified:

${c:data.csv}
Field0,Field1,Field2,Field3,Field4,Field5
"John PATTY",John,PATTY,555-12345,NY,JP
"Homer MAC CULLY",Homer,"MAC CULLY",555-32147,NH,HM
"Selma BOUVIER",Selma,BOUVIER,555-12378,KS,SB

--
Kiron