Hi
I'm creating a sh script to generate a csv file. The CSV contains the values from a sql table.
The content looks this:
a,b,c,c2,c3,,,,,,,,,,,d,e
I have some code that can separate the fields using the comma as delimiter, but some values actually contain commas, such as c,c2,c3,,,,,,,,,
This field needs to be taken as one field and the trailing commas after c3
must be removed.
Can anybody please help in doing this ?
Thanks in advance!!