awk pipes & print

Jonny2Vests · #1 (**permalink**) 02-19-2008

Hi,

I need to awk some data from some text files, basic stuff, eg:

awk '/phrase/ {print $1,$2,$3}' file

Which will print columns 1 to 3 of all lines containing "phrase"

But what if I wanted to pipe just one of the columns to a command (in my case a date converter) as in:

awk '/phrase/ {print $1 ¦ "command" ,$2,$3}' file

The above does not work. Does anyone know what does? I'm using ksh.

Cheers, Jon.

jim mcnamara · #2 (**permalink**) 02-19-2008

Your date converter has to be able to read from stdin. Your syntax is mostly correct. use getline to "retreive" your response on the other side of the pipe.

Code:

awk '/phrase/ {print $1 ¦ "command" | getline mydate; print mydate,$2,$3}' file

Test your date converter on the command line:

Code:

echo "$mydate" | date_converter

ynixon · #3 (**permalink**) 02-19-2008

try this

Code:

awk '/phrase/ {print $1,$2,$3 ; system("command "$1)}' file

Jonny2Vests · #4 (**permalink**) 02-19-2008

Quote:

Originally Posted by ynixon

try this

Code:

awk '/phrase/ {print $1,$2,$3 ; system("command "$1)}' file

Thanks guys and thanks for this ynixon, which is quite elegant and what I was looking for. I'm using:

awk '/phrase/ {system("command "$1" ");print $3" "$4}' file > output

...the only problem is the ; forces a new line. Any way around that?

Jon

fpmurphy · #5 (**permalink**) 02-19-2008

Here is another example using gawk

Code:

/phase/ {
      tmp = "date -r "$1;
      tmp | getline epoch;
      close(date);
      print epoch, $2, $3;
}

Sample file

Code:

2000  2 3 phase
90000 5 6 phase
7000  8 9

Output

Code:

Wed Dec 31 19:33:20 EST 1969 2 3
Thu Jan  1 20:00:00 EST 1970 5 6

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
named pipes	kanchan_agr	Shell Programming and Scripting	5	09-12-2007 05:48 AM
Print Problem in UNIX. Need to know the option to specify the print paper size	ukarthik	HP-UX	1	06-07-2007 09:35 AM
Two types of pipes?	blowtorch	UNIX for Dummies Questions & Answers	5	10-31-2005 09:35 PM
cd using pipes	Sinbad	Shell Programming and Scripting	2	09-09-2004 10:05 AM
PIPEs and Named PIPEs (FIFO) Buffer size	Jus	Filesystems, Disks and Memory	1	08-20-2004 10:14 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by