OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Help with csv file

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
nmccann
Newbie
Newbie


Joined: 12 Apr 2012
Posts: 1
Location: Bunmahon, Ireland

PostPosted: Thu Apr 12, 2012 4:29 am    Post subject: Help with csv file Reply with quote

I have a csv spreadsheet with 3000 + lines of data. I need to create new rows down trough the data. the new rows are to split existing text over new rows. Using replace I have tried placing \n at the required break point in the cells but this has not worked, any suggestions.



Moderation probe1: moved to CALC section, where this question seems to belong to; CODE SNIPPETS is for working code examples only; edited subject
Back to top
View user's profile Send private message Visit poster's website
DiGro
Super User
Super User


Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

PostPosted: Fri Apr 13, 2012 8:29 am    Post subject: Reply with quote

You'd beter off in a texteditor then in a spreadsheet.

Splitting CSV is easier done in texteditors like Notepad++, Notepad or even Writer. then in Calc.

In calc it requires selecting, copying/extracting from old cells and pasting in new cells.
It's probably easier to first edit the CSV-file and then import it into Calc.
If you persist on a spreadsheet
_________________
DiGro

Windows 7 Home Premium and AOO 4.0.1 NL (Dutch)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group