Shell Programming and Scripting

Hi all,
Am using awk to reformat an existing file

Code:

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

my question is, i would like to read lines that are starting with particular value only example

1,12,,2099,IF_TB001, 1
2,12,,2099, , 2
3,,103900002,100,110,103900002.116510.,,,,,EUR,, ,,,,, 47353.17, , , , CT_ACCT, , , , 0000000000, JDE, 3
3,,103900002,100,110,103900002.116510.,,,,,GBP,, ,,,,, -47353.17, , , , CT_ACCT, , , , 0000000000, JDE, 4

like my formatting should happen only on lines starting with 3 other lines startin with 1 and 2 should be discareded

I didn't catch what you wanted exactly, but here is a start:

Code:

awk '/^3/{print "5",$1,$28,$27,$26 }' OFS=, FS=, INP_FILE1

or

Code:

cat $INP_FILE1|grep ^3 | while read line
do
echo "$line" ...

Thank you...That worked perfectly

Try this, specified some random columns.

Code:

awk -F',' '$1 ~/^3/ { print $1,$2,$3,$6,$7 }' <Input filename>

I have problem here,

my input file has 5 lines starting with 3 but when i use the below code i get output only for 4 lines

Code:

 
cat $FILENAME |grep ^3 | while read line
do
nawk -v H1=$H1 -v H2=$H2 'BEGIN {FS=","} {..some  print formatting..}' >> NEW_FILE
done

is somewith wrong with the above stuff ?

even tried

Code:

 
cat $FILENAME |grep ^3 | while read line
do
echo "$line"| nawk -v H1=$H1 -v H2=$H2 'BEGIN {FS=","} {..some print formatting..}' >> NEW_FILE
done

We agree ^3 means char 3 as the very first char of the line ( so space then 3 is out!)... Is it absolutely the case?