Hi
So I have received a CSV where all the data is in the first column without any visible delimiter. However, when I copy the content of a cell into a text editor, I see that the different fields are separated with TABS but I am unable to split them in an excel spreadsheet.
The data would need to be separated into different columns.
Please find sample files attached for the messed-up csv & the sample text file (TAB delimited)
Kindly advise how I can salvage this data. There are over 17K total records in file
Many many thanks in advance
Bookmarks