1

Need Help - comma inside double quote in comma separated csv,

view story
linux-howto

http://www.unix.com – Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below, 1~234~"abc,12,gh"~"GH234TY"~34 (separator to be replaced by ~) or 1,234,"abc|12|gh","GH234TY",34 (comma inside double quote to be replaced by |) Note : Comma inside double quote can present in any column. It is not fixed that Comma inside double quote wil (HowTos)