Sample File (test.csv):
"PRCD-15234","CDOC","12","JUN-20-2016 17:00:00","title, with commas, ","Y!##!"
"PRCD-99999","CDOC","1","Sep-26-2016 17:00:00","title without comma","Y!##!"
Output file:
PRCD-15234|CDOC|12|JUN-20-2016 17:00:00|title, with commas, |Y!##!
PRCD-99999|CDOC|1|Sep-26-2016 17:00:00|title without comma|Y!##!
My script (doe not work) is below:
while IFS="," read f1 f2 f3 f4 f5 f6;
do
echo $f1|$f2|$f3|$f4|$f5|$f6;
done < test.csv