Shell Programming and Scripting

Hi there I have a file that I recieve that looks like the folowing, As these details are being manually entered by the customer, we sometimes get a few typos on 4th column (the 14 digit number starting with 42....) As you can see the first one has a space as the first character and then a 13 number string (this has been typed wrong)

I have been asked somehow remove any line that does not have th full 14 character numeric string beginning with 42 and place it in an exceptions file (thus insuring it doesnt get processed)


19-5-204057,161104,0090.09, 4209152509001,AUTH CODE:200395,0,101
19-5-204074,161104,0010.00,42067036239101,AUTH CODE:7935 ,0,101
19-5-204075,161104,0010.00,42067036239100,AUTH CODE:3145 ,0,101
23-5-185395,161104,0012.02,42071862819101,AUTH CODE:005932,0,101
23-5-185405,161104,0155.76,42079561219101,AUTH CODE:289603,0,101
23-5-185407,161104,0023.71,42055829039101,AUTH CODE:694281,0,101


I really have no idea where to start on this so any pointers would be great, has awk got the capability to do this ??

You could probably do it with awk, but I like my shell scripts!

Code:

#!/bin/sh

while read line
do
  echo "$line" | cut -d',' -f4 | grep "42[0-9]\{12\}" >/dev/null 2>&1
  if [ "$?" -eq "0" ]; then
    echo "$line" >> good_data
  else
    echo "$line" >> bad_data
  fi
done < testdata

Cheers
ZB

Maybe try egrep (or grep -E)

egrep -v '^[^,]*,[^,]*,[^,]*,[0-9]{14},' infile > badfile
egrep '^[^,]*,[^,]*,[^,]*,[0-9]{14},' infile >goodfile

Using awk ....

----------------------------

awk -F"," '{ if ($4 ~ / /) { } else
{ print $4 } }' testData

-----------------------------------