Fixed length flat file extraction


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Fixed length flat file extraction
# 1  
Old 10-13-2011
Fixed length flat file extraction

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:
Mod Comment Video tutorial on how to use code tags in The UNIX and Linux Forums.

Last edited by vbe; 10-13-2011 at 03:27 PM.. Reason: don't write in cyberchat
# 2  
Old 10-13-2011
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

# 3  
Old 10-13-2011
Single row fixed length flat file data extractration

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  
Old 10-13-2011
Quote:
Originally Posted by vbe
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

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 ----------

Quote:
Originally Posted by laxmi1166
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
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  
Old 10-14-2011
Code:
awk 'substr($0,13,3)=="100"{print substr($0,7,4);exit}' file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies

2. Shell Programming and Scripting

Flat file-make field length equal to header length

Hello Everyone, I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table. Input Data- ------ ------------------------ ---- ----------------- WFI001 Xxxxxx Control Work Item A Number of Records ------ ------------------------... (5 Replies)
Discussion started by: sonali.s.more
5 Replies

3. UNIX for Advanced & Expert Users

Insert Delimiter at fixed locations in a flat file

Hi Can somebody help me with solution for this PLEASE? I have a flat file and need to insert delimiters at fixed positions in all the lines so that I can easily convert into EXCEL with columns defined as per their width. For Example Here is the file { kkjhdhal sdfewss sdtereetyw... (7 Replies)
Discussion started by: jd_mca
7 Replies

4. Shell Programming and Scripting

reading fixed length flat file and calling java code using shell scripting

I am new to shell scripting and I have to to the following I have a flat file with storename(lenth 20) , emailaddress(lenth 40), location(15). There is NO delimiters in that file. Like the following str00001.txt StoreName emailaddress location... (3 Replies)
Discussion started by: willywilly
3 Replies

5. Shell Programming and Scripting

how to read fixed length flat file....

Hi Gurus, Thanks in advance... I am new to writing shell scripting and help me out reading a flat file with fixed length. I have a fixed length flat file with storename(lenth 6) , emailaddress(lenth 15), location(10). There is NO delimiters in that file. Like the following str00001.txt... (2 Replies)
Discussion started by: willywilly
2 Replies

6. Shell Programming and Scripting

Exporting a flat fixed length file (Urgent)

Hi All, So far, I've been extracting data from db2 tables and exporting the file as a tab delimited file into a UNIX server using the following command: export to /.../.../.../.../.../SM_RAW_DATA.dat of del modified by coldel| nochardel select a.accno, a.CUR_BL_AM, ... (1 Reply)
Discussion started by: jj2485
1 Replies

7. UNIX for Dummies Questions & Answers

Conditional sorting on fixed length flat file

I have a fixed length file that need to be sorted according to the following rule IF B=1 ORDER by A,B Else ORDER by A,C Input file is ABC 131 112 122 231 212 222 Output needed ABC 112 131 122 212 231 222 (1 Reply)
Discussion started by: zsk_00
1 Replies

8. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies

9. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

10. UNIX for Dummies Questions & Answers

Flat File Extraction

Hi all, I'm new in the unix environment. I'm having a challenge in extracting data from a flat file and convert it to a CSV file format or I should be able to open it with MS Excel. The input data in my flat file looks like this: AV00001001155000063637143326711145412082EM SITHOLE... (3 Replies)
Discussion started by: Mthimbana
3 Replies
Login or Register to Ask a Question

Featured Tech Videos