LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   General (http://www.linuxquestions.org/questions/general-10/)
-   -   dataset is in one collumn - how to split it into two c. ? (http://www.linuxquestions.org/questions/general-10/dataset-is-in-one-collumn-how-to-split-it-into-two-c-4175484034/)

sayhello_to_the_world 11-09-2013 01:53 PM

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

moxieman99 11-09-2013 02:37 PM

Quote:

Originally Posted by sayhello_to_the_world (Post 5061448)
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.

ceyx 11-09-2013 03:13 PM

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.


All times are GMT -5. The time now is 04:55 AM.