Shell Programming and Scripting

Hi all,

I have an input file like

Code:

1,date,company,,
1,date,comapny,,
2,000,,,567,ACT,00,,,,KKG,M1,D45,,67J,+4500000000
2,000,,,567,ACT,00,,,,KKG,M6,D49,,56J,+6000
2,000,,,567,ACT,00,,7,,KKG,M3,D58,,68h,-70000
2,000,,,567,ACT,00,,,,KKG,M9,D95,,34m,0.00
3,total

what i require is
1.I should add the last column starting with 2 to get the total credit and debit

the above question is solved am able to do that, but i wan to do it after going inside a script not in command line
2.then i would like to pick the last 10 columns of the lines starting with 2 and create a new file format like this
FYI - i will discard rest of the columns am interested only in last 10 columns

new required format

i would want to add X to first and last column in new format and if there is no value in source file then the new file will have just spaces(constant)...

The source files will be around 1500-2000 lines ...can you some one suggest me to write a script in awk,i do know shell scripting but, i was told awk is the best solution for this,am trying my best, would be happy if someone gives me some hints

Code:

X67J  D45M1KKG         X
X56J  D45M1KKG         X
X68h  D45M1KKG    7   X
X34m D45M1KKG         X

answer for first question
1.

Code:

credit_sum=`awk '{ value=substr($0, position, 12); if(value>0) {credit+=value}} END {print credit}' filename` 

debit_sum=`awk '{ value=substr($0, 74, 14); if(value<0) {debit+=value}} END {print debit}' filename`

2. ????

can you simply state your problem with some input file format and output file format.

---------- Post updated at 09:48 AM ---------- Previous update was at 09:20 AM ----------

Code:

 
lineno=`wc -l < inputfile`; nawk -F"," -v lineno="$lineno" '{ if (NR> lineno-10) {printf ("X%s %s%s%s %s X\n",$15,$13,$12,$11,$9)}}' inputfile

Ok fine ..i figured out a bit ...

here is the code
cat $INP_FILE1 | while read line
do
echo "$line" | nawk ' BEGIN {FS=","} {print("5",$1,$28,"$27",$26)}' >> $OUT_FILE1
done

But my question now is i want the above action to be performed only when the first column of the input file is having value 3 ..like when line starts with 2 or 1 it should skip those lines

Example of my input file :
1,12,,2099,IF_TB001, 1
2,12,,2099,, 2
3,,103900002,100,110,103900002.116510.,,,,,EUR,,,,,,,47353.17,,,,CT_ACCT,,,,0000000000,JDE,0.00, 3 3,,103900003,100,110,103900003.116510.,,,,,EUR,,,,,,,11457.13,,,,,,,,0000000000,JDE,0.00, 4


Output

0201107051728Corinthian FMCFS CTRON_GL 000188000000000098614.02-00 0000000098614.02+ 140 X
520110614088A20705K USD 0000000008177.41+14088A2000705K0000000000000000000000 X
520110614088471705K USD 0000000000225.00+1408847100705K0000000000000000000000 X