Shell Programming and Scripting

ls filename*.txt | awk -F".Y" '$2 < $v_RUN_DT && $2 > $v_LOAD_DT'|awk ' NR==1'
I am getting this error . Can somebody plz point me where is the problem.
awk: 0602-562 Field $() is not correct.
The input line number is 1.
The source line number is 1.

Code:

awk -F".Y" '$2 < vr && $2 > vl' vr="{v_RUN_DT}" vl="${v_LOAD_DT}" filename*.txt

Vgersh is there some problem in the code

awk -F".Y" '$2 < vr && $2 > vl' vr="{v_RUN_DT}" vl="${v_LOAD_DT}" filename*.txt

did u miss a $ in front of the v_run_dt

yes, I did - fat fingers!

Code:

awk -F".Y" '$2 < vr && $2 > vl' vr="${v_RUN_DT}" vl="${v_LOAD_DT}" filename*.txt

Hi Vgersh,

awk -F".Y" '$2 < vr && $2 > vl' vr="${v_RUN_DT}" vl="${v_LOAD_DT}" filename*.txt

The above command works fine but I now realised that its not giving the criteria
For ex:

awk -F".Y" '$2 < vr && $2 > vl' vr="20090502" vl="20090429" filename*.txt

I need the

filename.20090502.txt
filename.20090501.txt
filename.20090430.txt

But I am getting

filename.20090501.txt
filename.20090430.txt
filename.20090429.txt

I tried less than , greater than it doesn't give .. Can u plz point it out plz?

Thanks,

try this:

Code:

awk -F".Y" 'int($2) < int(vr) && int($2) > int(vl)' vr="${v_RUN_DT}" vl="${v_LOAD_DT}" filename*.txt

This is not working Vgersh

I am getting more files now