UNIX and Linux Forums - Search Results

Showing results 1 to 2 of 2 Search took 0.00 seconds. Search: Posts Made By: mathias23

Forum: Shell Programming and Scripting 11-14-2014

Shell script that should remove unnecessary commas between double quotes in CSV file

2,993

Posted By

thanks can u explain the 2nd code awk...

thanks can u explain the 2nd code
awk '!(NR%2){gsub(/, ?/," ")}1' RS=\" ORS=\" file

---------- Post updated at 03:51 AM ---------- Previous update was at 03:48 AM ----------

Forum: Shell Programming and Scripting 11-13-2014

Shell script that should remove unnecessary commas between double quotes in CSV file

2,993

Posted By

Shell script that should remove unnecessary commas between double quotes in CSV file

i have data as below

123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"

i need an output to be

123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre...

Showing results 1 to 2 of 2