Shell Programming and Scripting

Hi List,

I am sure this issue must have been encountered before. I have saved an excel CSV and sent it to my linux box where I require to parse it as a CSV line by line. The file displays fine in Excel with csv headers and consistent records and fields. However when I look at it in linux I see multiple carriage returns and double quotes which don't appear when viewing in Excel.

Is there any unix/sed/awk script about which I can use to run from my linux box to convert this excel format into a workable CSV which is parse-able with unix tools?

I am sure there must be a simple substitution script which can achieve this.

Does anyone have any ideas?

Thanks,
Land

Whatever the data has whitespace, the only way to preserve is to double quote the field. Unless you can be for sure that there will be no white space in the field, otherwise I would recommend you to use other programming language. I worked with Python csv module. Below links provide examples that you can reference:
Most of the modern systems system come with Python together with csv module. Do give it a try

Thanks that little bit of python nails it..