Fixed length flat file extraction

Shell Programming and Scripting
1

Hii ,I am new to Unix ,i have a flat file which is (fixed length) sitting in unix,Which is holding the data for a table.I want to extract one column(length7-10) on the basis of another column(length13-15) and want only one single row

Example:
Below is the sample of flat file.

1111 AAAA 100    US
2222 BBBB 200    IN
3333 CCCC 3000   UK

Result required:
I want 100 on the basis of AAAA

Your response should be appreciated....

Regards,
Laxmi

2 
ant:/home/vbe $ cat extractfile001
1111 AAAA 100    US
2222 BBBB 200    IN
3333 CCCC 3000   UK

ant:/home/vbe $ grep AAAA <extractfile001|awk '{print $2,  $3}'
AAAA 100
ant:/home/vbe $ grep AAAA <extractfile001|awk '{print $3}'        
100
3

Hii vbe
Thanks for the Reply ,But i am getting all the data under $2 ,$3(i have 9 million records under $2 , $3 ,attached the data below ) ..
I want single row data ,like (where condition in Sql). Can we get it in unix
kindly Advice.

VALLEYAREA AMBULANCE
VALLEYAREA AMBULANCE
ANTHONY MEDICAL
CHARLES COUNTY
CHARLES COUNTY
CHARLES COUNTY
CHARLES COUNTY
DOMINIC AMBULATORY
DOMINIC AMBULATORY
DOMINIC AMBULATORY
FRANCIS FIRE
JOHNS REGIONAL
JOSEPHS HOSPITAL
LUKES HOSPITAL
LUKES METHODIST
MARYS HOSP
MARYS HOSP
MARYS HOSPITAL
MARYS LIFEFLIGHT

thanks and regards
Laxmi

4

since already use awk command, no need grep

awk '/AAAA/{print $2,  $3}' extractfile001

---------- Post updated at 11:10 AM ---------- Previous update was at 11:07 AM ----------

Your new sourc file are totally different with your first topic, which has 4 column. Please let us know what your expect output from it.

5 
awk 'substr($0,13,3)=="100"{print substr($0,7,4);exit}' file