Issue reading csv file

UNIX for Advanced & Expert Users
1

HI All

I have csv file containing the data like this

Electrical Equipment,ElecEquip
"Engineering, Machinery & Equipment",Engineerin
Entertainment & Broadcasting,Entertain

The first and third record are fine,The issue with second records as it has comma enclosed with in inverted commas.I need to load the data with in inverted commas in single column .which is not the case.currently the data is beeing loaded as "Engineering in one column and Machinery in second.can you suggest me a script to read the data with out inverted commas .

Thanks in Advance

Mohammed Tausif

2

It's possible to read files in excel with different fieldseparators.
This should change the fieldseparator to ";" but not within the fields with double quotes:

awk -F "\"" ' {
  for(i=1;i<NF;i+=2) {
    gsub(",", ";", $i)
  }
}1' OFS="\"" file

Regards