The reason I chosen the quote-comma delimiter is because that was what I used to import a cvs file in ms excel back in the early 90's. Many cvs files were in that format at that time.
I believe the pipe delimiter can be used in a spreadsheet, so I tested it out.
I copied his original sample data from post 1 to a file called test.cvs with no modifications.
From libreoffice Calc, I opened the test.cvs and a text dialog box appears. From there you choose the options for dividing the data from the test.cvs file into columns by choosing the delimiter and text separator. Depending on the options you choose, you'll get to see a preview at the bottom on how the data will be divided in the columns.
Anyway, Long story short, it did work. So if libreoffice Calc can do it, MS excel can do it too.
OP just needs to know how to do it in MS Excel.
Last edited by WayneB; 03-20-2016 at 02:41 PM.
|