Search Results

Code:
awk -F'"' 'BEGIN{OFS="\""}{gsub(",","|",$2);print}' file.csv
awk: syntax error near line 1
awk: illegal statement near line 1

@Sheel, the code you gave is giving me syntax error :(

Can this be done by writing a script if a one line command is not possible.

Thanks Sheel... But it's possible that I have more that one fields wrapped inside in the last column as well, I need to somehow escape commas inside "". Really appreciate if you can provide an...

I tried cut -d but it takes the commas inside "" as well in count
while read line
do
OUTLINE=`echo $line | cut -d, -f1`","`echo $line | cut -d, -f4`
echo $OUTLINE
done < file.csv

I get...

Hello Gurus,

I need to create a file from a .csv file extracting specific columns only.

File structure is
Column1,Column2,Column3,Column4
abcd,1234,"asdf, tew,123",123456...