Shell Programming and Scripting

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.

Code:

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

Moderator's Comments:

Video tutorial on how to use code tags in The UNIX and Linux Forums.

Code:

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

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

since already use awk command, no need grep

Code:

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.

Code:

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