Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to separate fields with pipe character delimiter

Tags:

bash

sed

pipe

awk

ash

I know this question has already been asked but no of the solution I've found worked for me! I have a program that has an output like this:

COUNT|293|1|lps

I'm interested in having the second field however no one of these tries worked:

./spawn 1 | cut -d '|' -f2
./spawn 1 | cut -d \| -f2
./spawn 1 | awk -F "|" '{print $2}'
./spawn 1 | awk 'BEGIN{FS="|"} {print $2}'
./spawn 1 | sed 's/|/;/g'
./spawn 1 | sed 's/\|/;/g'

But the output is always the same:

COUNT|293|1|lps

Is there a bug somewhere in bash? I would be surprised, the results is the same on my Linux host and on my embedded device using busybox's ash! Any pointer is strongly appreciated!

EDIT My fault, the output was in stderr ... ._.

./spawn 1 2>&1 | cut -d '|' -f2
4615

Sorry for ennoying!

like image 389
morandg Avatar asked Jan 26 '12 13:01

morandg


1 Answers

Just repeating what I guessed in a comment as an answer, now that the questioner has confirmed that this is the problem.

The problem here is that ./spawn 1 is outputting to standard error, not standard output. You can redirect the output using 2>&1, so the following should work:

./spawn 1 2>&1 | cut -d '|' -f2
like image 9
Mark Longair Avatar answered Oct 20 '22 01:10

Mark Longair