list of words in a row to column?

rasat · 2005-04-13 05:43:39

How to change in text file to display each words in one column.

test0 test1 test2 test3

test0
test1
test2
test3

cactus · 2005-04-13 06:11:12

if you know then are always space seperated, and all there is is a list needing to be converted into a column..

tr ' ' 'n'

then just pipe the text through it..

cat file | tr ' ' 'n'

There are a myriad of other ways to do it, and coutless others depending on the utilities/programming languages, chosen.

rasat · 2005-04-13 07:51:30

cactus wrote:

cat file | tr ' ' 'n'

Thanks!

phrakture · 2005-04-13 14:55:21

sed "s/s*/n/g" file

might work too... and that will work on any number of whitespaces (tabs, spaces, etc)

rasat · 2005-04-13 15:16:15

Works too well.

[rasat@localhost /]$ sed "s/s*/n/g" test.tmp

t
e
s
t
t
e
s
t
1
t
e
s
t
2

[rasat@localhost /]$

phrakture · 2005-04-13 17:08:36

what the? what is "s"? am I backwards... maybe you you want "w"? I dunno... I'll have to bust out my sed reference later...

cactus · 2005-04-13 18:29:59

you want a plus instead of a star phrakture. Star also matches 0 occurances. Plus is one or more.

phrakture · 2005-04-13 19:35:23

Ahhhh... that's it...

sed "s/s+/n/g" file

rasat · 2005-04-14 02:45:51

No plus or star does the job.
sed "s/s/n/g"

phrakture · 2005-04-14 02:58:27

yeah, but that only works for a single whitespace.... try two spaces and you'll get multiple newlines...

lel7lel7 · 2010-06-24 00:18:07

Hi,
These codes have not worked for me, i am unsure why...
My data is in the form..

[lg45@dev64-mgmt ~]$ echo $start
25293633 7393500 10578865 25293623 122206254 26797134 41906484

but i have also tried saving it as a new file 'nano.txt' - either way the sed and "tr '' 'n'" methods give me random results such as
n2n5n2n9n3n6n3n3n and 25293633n7393500n10578865n2...

Any suggestions would be great

andresp · 2010-06-24 00:22:52

$ tr \ \\n <<<'25293633 7393500 10578865 25293623 122206254 26797134 41906484'

Procyon · 2010-06-24 00:28:11

New forum software probably messed those posts up removing backslashes.

Putting the backslashes back:
echo a b c | tr ' ' '\n'
echo a b c | sed 's/\s\+/\n/g'

karol · 2010-06-24 00:46:31

2005-04-14
ooooooooooooooooooold thread

Allan · 2010-06-24 01:21:25

http://wiki.archlinux.org/index.php/For … Bumping.27
Closing.

Arch Linux

#1 2005-04-13 05:43:39

list of words in a row to column?

#2 2005-04-13 06:11:12

Re: list of words in a row to column?

#3 2005-04-13 07:51:30

Re: list of words in a row to column?

#4 2005-04-13 14:55:21

Re: list of words in a row to column?

#5 2005-04-13 15:16:15

Re: list of words in a row to column?

#6 2005-04-13 17:08:36

Re: list of words in a row to column?

#7 2005-04-13 18:29:59

Re: list of words in a row to column?

#8 2005-04-13 19:35:23

Re: list of words in a row to column?

#9 2005-04-14 02:45:51

Re: list of words in a row to column?

#10 2005-04-14 02:58:27

Re: list of words in a row to column?

#11 2010-06-24 00:18:07

Re: list of words in a row to column?

#12 2010-06-24 00:22:52

Re: list of words in a row to column?

#13 2010-06-24 00:28:11

Re: list of words in a row to column?

#14 2010-06-24 00:46:31

Re: list of words in a row to column?

#15 2010-06-24 01:21:25

Re: list of words in a row to column?

Board footer