How to delete Comma in a comma separated file with double quotes as quote character
Dear Experts I am new to the linux please help me with the following
I am transfering a csv file with the double quotes as quote character from Linux to Windows during this process one of the columns data is getting disturbed and written to more than one column due to the presence of comma between the double quoted column data. How can I delete the comma present with in the column data before I transfer the file from Linux to Windows. I tried few 'sed' commands but no luck. Thanks very much in advance. |
Quote:
Chances are, the file isn't getting corrupted in transfer, and affecting just one column. Since you don't say how you're generating it, it's hard to give options, but you could try to generate a tab-delimited file, then run it through sed to strip out the commas, and sed it again, to replace the tabs with commas, leaving you with a 'sanitized' file. Without having any real information or samples of data, it's hard to say. |
Quote:
Look here for some relevant info (unix2dos): http://linux.die.net/man/1/unix2dos (there's a link at the bottom for dos2unix) |
All times are GMT -5. The time now is 07:20 AM. |