Shell Programming and Scripting

Hi,

i have a problem writing a script.
Actually i have many files which contains some data, now the last line has some data as in the format : 2556||04-04-10
now i want to do tail -1 filename.txt and store the result into a variable which will be used later for some other calculations.
My problem is how to include jus first numeric digits (2556 here) and store date in another variable (04-04-10 here).
These stored data would be then stored into some other text file.I have multiple files so would be creating script for this.

Please help me out with the solution.
Thanks
Tc.

something like?

Code:

var1=$(tail -1 file | awk -F "|" '{print $1}')
var2=$(tail -1 file | awk -F "|" '{print $3}')

Thanks Anchal for the help.....but I am getting following error....

$ tail -1 a.txt | awk -F "|" '{print $1}'
awk: syntax error near line 1
awk: bailing out near line 1

n cant sort where is the error..!

To loop through the *.txt files in a directory you can do something like:

Code:

for file in *.txt
 tail -1 "$file" | awk -F"|" '{print $1, $NF}' | read num dat
 # Do something with $num and $dat
 # other stuff
done

Use nawk or /usr/xpg4/bin/awk on Solaris.

Code:

eval `awk -F\| 'END{printf "var1=%s var2=%s",$1,$3}' file`

Code:

L="$(tail -1 file)"
NUM=${L%%|*}
DAT=${L##*|}

Thanks Franklin, danmero and frans. !!!

Gr8 code frans.

Now workin on makin num and dat as array so as to use it in later stage to format my output...!
lets c if i can, or else wil revert back to u al guys again...