Awk not printing the last combined column

pinnacle · #1 (**permalink**) 05-08-2009

Code:

nawk -F "|" 'FNR==NR {a[$1]=$2 OFS $3 OFS $4 OFS $5 OFS $6;next}\
{if ($5 in a)print $1,"test",$5,a[$5], $2,$3,$4 OFS OFS OFS OFS OFS OFS OFS OFS $2-$3-$4 ; \
else print $1,"Database",$5 OFS OFS OFS OFS OFS OFS $2,$3,$4 OFS OFS OFS OFS OFS OFS OFS OFS $2-$3-$4 }' OFS="|" \
file1 file2 > file3

This works fine except the last part where

Code:

$2-$3-$4

i want to print $2$3$4 in one field seperated by -
it is printing 0

Appreciate help

vgersh99 · #2 (**permalink**) 05-08-2009

why do you think it's doing that?

pinnacle · #3 (**permalink**) 05-08-2009

Quote:

Originally Posted by vgersh99

why do you think it's doing that?

I think i should use printf but i am not aware how to use it while printing an array.

I dont know why it is doing that.

vgersh99 · #4 (**permalink**) 05-08-2009

Hint: Is '-' a 'dash' or a 'minus' in your context?

pinnacle · #5 (**permalink**) 05-08-2009

Quote:

Originally Posted by vgersh99

Hint: Is '-' a 'dash' or a 'minus' in your context?

Actually i was about to post

i myself also figured it out and used

Code:

$2"-"$3"-"$4

Thanks vgersh99 and devtakh

devtakh · #6 (**permalink**) 05-08-2009

Quote:

Originally Posted by zenith

Code:

nawk -F "|" 'FNR==NR {a[$1]=$2 OFS $3 OFS $4 OFS $5 OFS $6;next}\
{if ($5 in a)print $1,"test",$5,a[$5], $2,$3,$4 OFS OFS OFS OFS OFS OFS OFS OFS $2-$3-$4 ; \
else print $1,"Database",$5 OFS OFS OFS OFS OFS OFS $2,$3,$4 OFS OFS OFS OFS OFS OFS OFS OFS $2-$3-$4 }' OFS="|" \
file1 file2 > file3

This works fine except the last part where

Code:

$2-$3-$4

i want to print $2$3$4 in one field seperated by -
it is printing 0

Appreciate help

use $2"-"$3"-"$4 instead or it will be treated as minus and try to substract.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Changing one column of delimited file column to fixed width column	manneni prakash	Shell Programming and Scripting	5	06-22-2009 06:27 AM
How to combined file?	jantzen16	Shell Programming and Scripting	7	12-25-2008 05:46 AM
How to combined to file with their values	jantzen16	Shell Programming and Scripting	5	12-22-2008 10:03 AM
printing in certain column based on some result	kumar_amit	Shell Programming and Scripting	6	12-12-2008 03:51 PM
Help with script printing column with space	n3al10	Shell Programming and Scripting	4	12-16-2007 05:42 PM

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