I'm converting a text file with strings such as this into a form that can be read by another application.
"2JC","0278294","JP Morgan Life UK Liquidity 3",E
I need to get rid of the quotes characters but keep the data separated by the commas.
As I open the txt file into Excel, the Text Import Wizard appears and recognizes the file as Delimited.
I follow the steps and, at Step 2, I choose Comma as the delimiter.
However, when I come to save the file as a TXT, the commas that separated the data have gone. (The Save As dialogue box only offers Text (Tab Delimited) as an option for Text files.)
The application that I'm going to import into needs those commas to separate the various items of data.
Is there a way to retain (or restore) the commas?
Thanks.
Bookmarks