LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-29-2016, 04:30 PM   #1
pwabrahams
Member
 
Registered: Nov 2005
Location: Deerfield MA
Distribution: OpenSuSE, Kubuntu
Posts: 290

Rep: Reputation: 41
Text to columns in LIbre Office 4.2.8.2


I'm running Libre Office Calc 4.2.8.2. I have a spreadsheet of text cells in which I want to split each cell at a delimiter (newline). I did a search on how to do this and came up with the answer (from several sources) to select the cells, then go to Data/Text to Columns. That ought to work -- except that when I go to the Data menu, Text to Columns is not one of the choices. Is this a version problem? For 4.2.8.2, what is another way to do the same thing? And how do I specify newline as the delimiter? (/n splits it at the letter n.)

Last edited by pwabrahams; 12-29-2016 at 04:34 PM.
 
Old 12-29-2016, 04:36 PM   #2
hydrurga
LQ Guru
 
Registered: Nov 2008
Location: Pictland
Distribution: Linux Mint 19.1 MATE
Posts: 8,018
Blog Entries: 5

Rep: Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872
Just for info, it works on my LibreOffice 5.1.4.2 installation. The functionality has been around for several years so I imagine that it should work in your version.

If you haven't done so already, try selecting only those cells that have your data in them, nothing else, before Data->Text to Columns.
 
1 members found this post helpful.
Old 12-29-2016, 05:48 PM   #3
pwabrahams
Member
 
Registered: Nov 2005
Location: Deerfield MA
Distribution: OpenSuSE, Kubuntu
Posts: 290

Original Poster
Rep: Reputation: 41
Line break as delimiter

How about the other problem: specifying a line break as the delimiter?
 
Old 12-30-2016, 03:13 AM   #4
hydrurga
LQ Guru
 
Registered: Nov 2008
Location: Pictland
Distribution: Linux Mint 19.1 MATE
Posts: 8,018
Blog Entries: 5

Rep: Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872
Normally in Linux a new line is specified by \n, not /n.

The problem here is that if Calc meets a newline in a cell during Text to Columns then it splits the cell into 2 rows in addition to taking the split character into account. Did you not experience this?
 
Old 12-31-2016, 11:06 PM   #5
pwabrahams
Member
 
Registered: Nov 2005
Location: Deerfield MA
Distribution: OpenSuSE, Kubuntu
Posts: 290

Original Poster
Rep: Reputation: 41
Finally gave up

Since the file wasn't long, I finally just gave up and manually replaced each newline by a %. (I had fixed the \n versus /n problem but it didn't help.)
 
Old 01-01-2017, 06:21 AM   #6
hydrurga
LQ Guru
 
Registered: Nov 2008
Location: Pictland
Distribution: Linux Mint 19.1 MATE
Posts: 8,018
Blog Entries: 5

Rep: Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872Reputation: 2872
Quote:
Originally Posted by pwabrahams View Post
Since the file wasn't long, I finally just gave up and manually replaced each newline by a %. (I had fixed the \n versus /n problem but it didn't help.)
That sounds like a good move given LibreOffice's apparent inability to do what you wanted. I'm glad you got it sorted.

Another option would have been to copy the data out into your favourite text editor, run a find-replace operation there to replace the newlines by some other separator character such as a tab, and then copy the results back in to LibreOffice.
 
1 members found this post helpful.
  


Reply

Tags
cacl


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 keep columns set at certain width in Libre Office Writer 4.2.7.2 from changing 1sweetwater! Linux - Software 17 10-26-2016 01:30 PM
how to import text out of .txt file and put/sort them in a libre office tables? webodin Linux - Newbie 4 03-11-2016 07:00 AM
libre office writer table 4.2.7.2 build 2 hilight text to change font or move & page 1sweetwater! Linux - Software 0 12-05-2014 06:44 AM
Unoconv Convertor for RHEL 6 : Libre office & open office utility vishwajeet jagtap Linux - Software 0 02-15-2013 10:44 AM
printing document comments on same page with text Libre/Open-Office SaintDanBert Linux - Software 4 11-15-2011 05:10 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:46 PM.

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