awk comparing a column value with a stored variables value

bugg_deccan · 12-05-2008, 04:05 AM

hi,

I have a value stored in a variable. I want to call that variable's value and equate it with a column in awk.

Code:

dt=$(ls -ltr *.Z|head -1|awk '{print $7}')
ls -ltr|awk '($7==$dt){print "mv "$9" /ANOTHER/LOCATION"}'>mov_tzt.sh

But this is throwing an error. Can any one help me out please

colucix · 12-05-2008, 05:25 AM

To pass the value of a shell variable to awk you have to use the -v option. For example:

Code:

awk -v dt=$dt 'the_awk_program_here'

the reason is that you embed the awk program in single quotes and they prevent the shell to do any substitution, that is the string "$dt" is interpreted literally. Take a look here and here for more details.

bugg_deccan · 12-05-2008, 05:39 AM

Hi colucix

Thanx for the reply.

I edited the code

Code:

dt=$(ls -ltr *.Z|head -1|awk '{print $7}')
ls -ltr|awk '($7=='$dt'){print "mv "$9" /ANOTHER/LOCATION"}'>mov_tzt.sh

Now the script is workin cool.

colucix · 12-05-2008, 06:04 AM

Very good!

ghostdog74 · 12-05-2008, 07:08 AM

Quote:

Originally Posted by bugg_deccan

hi,

I have a value stored in a variable. I want to call that variable's value and equate it with a column in awk.

Code:

dt=$(ls -ltr *.Z|head -1|awk '{print $7}')
ls -ltr|awk '($7==$dt){print "mv "$9" /ANOTHER/LOCATION"}'>mov_tzt.sh

But this is throwing an error. Can any one help me out please

Code:

ls -ltr *.txt|awk 'NR==1{dt=$7}$7==dt{print "mv "$9" /ANOTHER/LOCATION"}'