|
|
Change the delimiter from Comma to Pipeline
12-17-2012
awk -F '"' 'NF>1{ for(i=1;i<=NF;i+=2){gsub(",","|",$i)}}
NF==1{gsub(",","|")}1' OFS="" fileawk -F '"' 'NF>1{ for(i=1;i<=NF;i+=2){gsub(",","|",$i)}} # For FS='"' (doble quotes), If NF(number of fields) is more than 1 then use for loop and replace "," with "|" for all odd entries of fields.
Odd entries marked as Red.
Menstrain,A0022699,"Woodstock,IL,2",A0013195,"Rockford,IL"
NF==1{gsub(",","|")}1' OFS='"' file # When file don't have any FS('"') in it then NF==1. then replace all the entries of "," with "|". and Set OFS='"' to regain all double quotes.
12-17-2012
12-17-2012
urx02:mmadusr:/development/mma/az/data> awk 'NR%2{gsub(/,/,"|")}1' RS=\" ORS= DCIA_C150_R01_PLN_SEG_DATA.TXT > pp1.txt
awk: Input line
0000030075,IPA,4,AE cannot be longer than 3,000 bytes.
The input line number is 44. The file is DCIA_C150_R01_PLN_SEG_DATA.TXT.
The source line number is 1.0000000000,,3,MAIL ORDER,MAIL ORDER DATA,N/A,MAIL ORDER,N/A, 0000010001,CASH,1,CASH,CASH,N/A,CASH,N/A, 0000020002,FFS MED,2,AL MEDICAID,MEDICAID,N/A,AL MEDICAID,N/A,"Tier2,PA,NPF" 0000020003,FFS MED,2,ALASKA MEDICAID,MEDICAID,N/A,ALASKA MEDICAID,N/A,"Tier1,ST,PA"
|
|
|
|