Shell Programming and Scripting

Dear members..

I have a fixed width file. Requirement is as below:-
1. Scan each record from this fixed width file
2. Check for value under field no "6" equals to "ABC". If yes, then filter this record into the output file

Please suggest a unix command to achieve this, my guess awk might work here

Thanks in advance
Suresh

Please post some example lines using code tags.

Code:

$ cat sample2.txt
AB DFDF GFGF BB DDFDFDDG ABC 1234
BB WKSK 12SD AA SHJDSDDS DEF 1345
GH SDSD 7878 99 DHFDFDFG ABC 3434

$ awk '{if (substr($0,26,3)=="ABC") print}' sample2.txt
AB DFDF GFGF BB DDFDFDDG ABC 1234
GH SDSD 7878 99 DHFDFDFG ABC 3434

Dear members..

I am further refining my requirement as below:-

I have a fixed width file. Requirement is as below:-
1. Scan each record from this fixed width file
2. Check for value under field no "6" equals to "6". If yes, then filter this record into the output file

Please suggest a unix command to achieve this, my guess awk might work here

Illustration below:-
----------------

Suppose source file has 3 records as below

123456789 => As per requirement, this record should flow into output
123459789 => This records should NOT go to ouput
123455789 => This records should NOT go to ouput
658986215 => As per requirement, this record should flow into output

Code:

% cat > testfile
123456789 => As per requirement, this record should flow into output
123459789 => This records should NOT go to ouput
123455789 => This records should NOT go to ouput
658986215 => As per requirement, this record should flow into output

% cat testfile | awk '{print $1}' | awk -vFS= '$6 == 6'

Code:

grep "^.....6" filename > output.txt

Thanks guys for quick solutions..it works now