I have an excel file, I would like to know a way to export that into a flat file with a custom delimiter like '|' or '&'.
Challenge is, This file has tabs inside one of the columns, This tab is enclosed in quotes. So, I don't want to replace the columns with tabs, but replace the tabs that separing columns.
1 ABC Company John Doe "He is 21 years old <tab> He lives in Colorado"
This should be extracted to:
This should be extracted to a flat file:
1|ABC Company|John|Doe|He is 21 years old<tab>He lives in Colorado"
Any help is greatly appreciated.