How do I alter this command so that it prints only the second comma delimited field from line number 3? Secondly, how do you redirect the output to a variable called TEST?

Thanks

(cat BATCH007.TXT | awk 'BEGIN { FS = "," } ; {print $2 }')

this is a sloppy answer, so it's not good if this is a homework assignment, but you can do:

TEST=$(head -3 BATCH007.TXT | tail -1l | awk '{FS=","} {print $2}')

try:

Thank You. Both lines work, but
what is the purpose of the "-1l " options on the tail, in this command?:

TEST=$(head -2 BATCH007.TXT | tail -1l | awk '{FS=","} {print $2}')

the 'head -2' pulls the top two lines of the text file, the 'tail -1l' pulls the bottom of those 2, so it's the second line of the file. Yogesh's method is cleaner and doesn't require external unix commands, but I couldn't remember the awk variable to get the current row number..

Shorther: