LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices

Reply
 
Search this Thread
Old 11-09-2013, 01:53 PM   #1
sayhello_to_the_world
Member
 
Registered: May 2013
Posts: 157

Rep: Reputation: Disabled
dataset is in one collumn - how to split it into two c. ?


hello and good evening

have a dataset - it looks like the one below

in one column is all included


myname1 www.myname.de
myname2 www.myname2.de
myname3 www.myname3.de
myname4 www.myname4.de
myname5 www.myname5.de
myname6 www.myname6.de


how to arrange that i have


a. in collumn 1 the names ; .... myname1 myname2 etx etc
b. in collumn 2 the websites - www.myname.de1 www.myname2.de www.myname3.de

is there a way to get there !?

i am pretty new to calc

any and all help will be appreciated

yours - say-hello-to the world
 
Old 11-09-2013, 02:37 PM   #2
moxieman99
Member
 
Registered: Feb 2004
Distribution: Dabble, but latest used are Fedora 13 and Ubuntu 10.4.1
Posts: 413

Rep: Reputation: 82
Quote:
Originally Posted by sayhello_to_the_world View Post
hello and good evening

have a dataset - it looks like the one below

in one column is all included


myname1 www.myname.de
myname2 www.myname2.de
myname3 www.myname3.de
myname4 www.myname4.de
myname5 www.myname5.de
myname6 www.myname6.de


how to arrange that i have


a. in collumn 1 the names ; .... myname1 myname2 etx etc
b. in collumn 2 the websites - www.myname.de1 www.myname2.de www.myname3.de

is there a way to get there !?

i am pretty new to calc

any and all help will be appreciated

yours - say-hello-to the world
I assume you are using OOo Calc or LibreOffice Calc?

Check out the "Left" and "Right" read commands. You can make Column B the left "x" number of characters of Column A and Column C as the right number of characters of Column A. I think there is even a way to subtract a string from another string ("ABC" - "A" = "BC"), but I may be wrong.

NOW BACK UP YOUR WORK TO ANOTHER FILE.

Then in columns D and E, copy columns B and C as absolute values, NOT as references. Finally, blow away columns A, B, and C. You will be left with the two columns of data you want.


----------------------
I just checked it out in OOo. If cell A1 contains (without quotes) "abcdefghijk" as text and in cell B1 you use the formula (without quotes) "=LEFT(A1; 5)", abcde will appear in cell B1. Just remember that that is a reference value, so you have to copy it to another place as an absolute value.

Last edited by moxieman99; 11-09-2013 at 02:50 PM.
 
Old 11-09-2013, 03:13 PM   #3
ceyx
Member
 
Registered: May 2009
Location: Fort Langley BC
Distribution: Ubuntu 11, Arch, / Gnome 3.X, OSX,Windows
Posts: 170

Rep: Reputation: 36
Try this :

In Calc, select the column in question, go to Data > Text to Columns. It will split them into two if you select 'space' as the delimiter. There are other delimiters to try too.
 
  


Reply


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
Problem Sending a dataset to excel in c# mrobertson Programming 14 03-07-2006 07:26 AM
passing a dataset from one sub to another mrobertson Programming 2 03-03-2006 07:39 AM
Printing a datagrid/dataset in c# mrobertson Programming 1 02-27-2006 03:43 PM
Displaying an oracle dataset on a datagrid using C# mrobertson Programming 1 01-11-2006 02:34 PM
132 collumn terminal frieza Linux - General 1 02-23-2004 10:29 AM


All times are GMT -5. The time now is 06:48 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration