in ksh.
Here is what I have working thanks to all of you. Now I need to take it one step further. The $result value needs to be in the $0000.00 format instead of what it is now, 000000. Yes, it is always 6 characters, I thought this would help but so far it has baffled me.
My thought was to pull the right two numbers into one variable and left 4 numbers into another, then concat them with a dollar sign in front. But I cannot get it to work right.
This is what I have that works right now:
num=`grep "^X1" <filename|cut -c26-31`
result=`echo $num | awk '$1=$1' OFS="+" | bc`
echo "Total Dollar amount is $result"