I have a CSV with 6 coloumn. I need to replace a ',' with '|' in the 4th coloumn of a CSV only so i can upload in Database. When i Upload now, commas used in the text in the 4th coloumn are treated as delimiter and remaining text goes to the next coloumn. Any solutions to replace, thanks.
It would help if you could share some sample input and desired output. Just a few representative records, but feel free to sanitise it for keeping personal or company details safe.
Robin
1 Like