Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 03-20-2016, 01:03 PM   #16
Michael Uplawski
Registered: Dec 2015
Location: Normandy, France
Distribution: Debian buster/sid
Posts: 555
Blog Entries: 18

Rep: Reputation: 365Reputation: 365Reputation: 365Reputation: 365

The OP has posted further above:
Correct, the rows data has to be converted to column data
And just before that post, I had already stated, that Gnumeric imports the pipe-delimited file directly. I do not know about LibreOffice but SoftMaker PlanMaker can do it, too.


That is not the OP's problem.
Old 03-20-2016, 03:30 PM   #17
LQ Newbie
Registered: Mar 2016
Posts: 25

Rep: Reputation: Disabled
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 03:41 PM.
Old 03-22-2016, 05:32 AM   #18
Registered: Oct 2012
Posts: 36

Original Poster
Rep: Reputation: Disabled
Thumbs down

Yeah.. Thanks you .
The command provided worked.....


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] How to extract an entire row of one file based on a matching column in a CSV file arbex5 Programming 13 07-27-2015 02:54 PM
retrieve data column wise from csv files srinureddy Linux - Newbie 16 11-01-2014 07:54 AM
Help needed - How to check quality of a specific column in a tab-delimited file? Jason7449 Linux - Newbie 3 03-08-2010 10:36 AM
Bash - Reading csv delimited file to array and for further manipulation BLWEGRZYN Programming 1 01-06-2010 10:38 PM
Culling Data from a CSV file to output in excel jterr02 Programming 2 05-19-2006 05:58 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 10:24 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration