split line...

DoME69 · 03-19-2010, 11:14 AM

Hi ...

I have the file below..

kuku, 12 34,AAAA,BB,99
DUDU,43,ggg,hhh,66666
dora,goo, 345 , 677, yyy

How can i outpot only the second column.

Output file: 12 34
43
goo

Thanks.

Nylex · 03-19-2010, 11:17 AM

You can use awk. Let's assume the text is stored in a file called "stuff". Then, you can use

cat stuff | awk -F ',' '{print $2}',

where -F specifies the separator between entries on a line and then we simply print the second column.

neonsignal · 03-19-2010, 08:05 PM

You can also use cut, eg

Code:

cut -d ',' -f 2 <input.txt

(the -d specifies the separator, and the -f specifies the field)

...since there's more than one way to skin a cut

ghostdog74 · 03-19-2010, 09:53 PM

Quote:

Originally Posted by Nylex

You can use awk. Let's assume the text is stored in a file called "stuff". Then, you can use

cat stuff | awk -F ',' '{print $2}',

where -F specifies the separator between entries on a line and then we simply print the second column.

no need cat. its useless.

Nylex · 03-20-2010, 01:52 AM

Quote:

Originally Posted by ghostdog74

no need cat. its useless.

Sorry :/. Didn't know that..

Sergei Steshenko · 03-20-2010, 07:59 AM

Quote:

Originally Posted by Nylex

Sorry :/. Didn't know that..

Well, 'cat' in this case was used to convert file into stream, which was redundant. I.e. 'cat' by itself is not useless, but its usage was redundant because 'awk' can get its input from a file.