Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Parse a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parse a file
# 1  
Old 03-28-2011
Parse a file
FILE1

Code:
 
2917,065A,RDF1+TDEV,2917_3RAID5,05E:0_10E:0,BL_lmwsp02,0345,xxx,3452(DR)
2917,03EA,RDF1+TDEV,2917_3RAID5,03E:0_12E:0,BL_tv00p02,0455,xxx,3ee4(DR)
2917,03EB,RDF1+TDEV,2917_3RAID5,03E:0_12E:0,BL_tv00p02,0345,xxx,2d34(DR)
2917,04FE,RDF1+TDEV,2917_3RAID5,05E:0_10E:0,BC_ht00p01,2e22,xxx,3456(DR)

OUTPUT FILE 2
Code:
 
0345,RL_lmwsp02
0455,RL_tv00p02
0345,RL_tv00p02
2e22,RC_ht00p01

In file 2 1st column is the 7th column of file 1 and the 2nd column is 6th column of
file 1 with first alphabet replaced by "R"

OUTPUT FILE 3
Code:
 
05E:0_10E:0,RL_lmwsp02
03E:0_12E:0,RL_tv00p02
03E:0_12E:0,RL_tv00p02
05E:0_10E:0,RL_ht00p01

In file 3 1st column is the 5th column of file 1 and the 2nd column is 6th column of
file 1 with first alphabet replaced by "R"

OUTPUT FILE 4
Code:
3452,DL_lmwsp02
3ee4,DL_tv00p02
2d34,DL_tv00p02
3456,DC_ht00p01

In file4 1st column is the column in file 1 which contains "(DR)" ,which may not always be $9 and the 2nd column is 6th column of
file 1 with first alphabet replaced by "D"

Thanks
# 2  
Old 03-28-2011
Code:
awk 'BEGIN{FS=OFS=","}{print $7,"R"substr($6,2) >"FILE2";print $5,"R"substr($6,2) >"FILE3";print gensub(/\(DR\)/,"",1,$NF),"D"substr($6,2) >"FILE4"}' FILE1

# 3  
Old 03-28-2011
Hi yinyuemi ,

the nawk i have on the system does not support gensub ,
nawk: calling undefined function gensub
i tried gsub but get a error ...is there another alternative

Thanks
# 4  
Old 03-28-2011
Code:
awk -F"," '{print $7",R"substr($6,2) > "FILE2";print $5",R"substr($6,2) > "FILE3"; print $NF",D"substr($6,2) > "FILE4";}' inputfile

# 5  
Old 03-28-2011
tene,

i want to find the column with (DR) in it ..and print its value without (DR) ...this not doing that
thx
# 6  
Old 03-28-2011
Try this.

Code:
awk -F"," '{print $7",R"substr($6,2) > "FILE2";print $5",R"substr($6,2) > "FILE3"; print substr($NF,1,4)",D"substr($6,2) > "FILE4";}' > inputfile

# 7  
Old 03-28-2011
Hi tene ,

sorry about the confusion , only problem is that the column with (DR) in it , may not always be same , so its more like search for the column containing (DR) word and print the value without (DR) ....thx
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to parse a file?

Hi guys I have a very long file which looks like this: y893 89:send prctmgr exit 106:bas_services_dwn -------------------------------------------------- y895 90:send prctmgr exit 106:bas_services_dwn -------------------------------------------------- y897 90:send prctmgr exit... (3 Replies)
Discussion started by: aoussenko
3 Replies

2. Shell Programming and Scripting

Parse a file using awk

Hi Experts, I am trying to parse the following file; FILEA a|b|c|c|c|c a|b|d|d|d|d e|f|a|a|a|a e|f|b|b|b|boutput expected: a<TAB>b <TAB><TAB>c<TAB>c<TAB>c<TAB>c<TAB> <TAB><TAB>d<TAB>d<TAB>d<TAB>d<TAB> e<TAB>f <TAB><TAB>a<TAB>a<TAB>a<TAB>a<TAB> <TAB><TAB>b<TAB>b<TAB>b<TAB>b<TAB>*... (7 Replies)
Discussion started by: rajangupta2387
7 Replies

3. Shell Programming and Scripting

parse fasta file to tabular file

Hello, A bioperl problem I thought could be done with awk: convert the fasta format (Note: the length of each row is not the same for each entry as they were combined from different files!) to tabular format. input.fasta: >YAL069W-1.334 Putative promoter sequence... (6 Replies)
Discussion started by: yifangt
6 Replies

4. Shell Programming and Scripting

parse file names

trying to parse out all parts of this file name. REC=`echo "CAMXI.F0150.txt" | sed 's/.*\(*\).*/\1/'` export "FLRECL=$REC" FLECL=0150 I can get the numbers 0150 out of the file name. But need to capture first 5 bytes and extension. So i would export 3 variables (name, length, extension)... (5 Replies)
Discussion started by: rapalanlord
5 Replies

5. Shell Programming and Scripting

need to parse the jil file into an excel file

Hi I have the following as input /* ----------------- backupJIL ----------------- */ insert_job: backupJIL job_type: c command: autorep -J ALL -q > /home/autosys/...p/autosys_jil_bk machine: machine owner: autosys@machine permission: gx,ge,wx,we date_conditions: 1 days_of_week:... (7 Replies)
Discussion started by: ramky79
7 Replies

6. Shell Programming and Scripting

Parse file from remote server to calculate count of string existence in that file

Hi I need to parse the file of same name which exist on different servers and calculate the count of string existed in both files. Say a file abc.log exist on 2 servers. I want to search for string "test" on both files and calculate the total count of search string's existence. For... (6 Replies)
Discussion started by: poweroflinux
6 Replies

7. UNIX for Advanced & Expert Users

How to parse through a file and based on condition form another output file

I have one file say CM.txt which contains values like below.Its just a flat file 1000,A,X 1001,B,Y 1002,B,Z ... .. total around 4 million lines of entries will be in that file. Now i need to write another file CM1.txt which should have 1000,1 1001,2 1002,3 .... ... .. Here i... (6 Replies)
Discussion started by: sivasu.india
6 Replies

8. Shell Programming and Scripting

Need help to parse the file

# Start "ABC" SFFd 0 4 Time SFFT 4 8 {Sec} User SFFTimeVal 12 8 {Sec} # Start "CP" SFFT ... (3 Replies)
Discussion started by: navsharan
3 Replies

9. Shell Programming and Scripting

Parse file

Hi Friends, I have a file in the format shown (Name followed by address:) I need only the address part please see the output. I have tried using nawk but I am not getting the desired output. SAM ADDRS 64874 FRANKLYN DR IRVINE TX - 74394; 538 FRED ASSOCIATES PETER ADDRS 84734... (5 Replies)
Discussion started by: sbasetty
5 Replies

10. Tips and Tutorials

12 Ways to Parse a file

A common thing in shell scripting. I came across this script that will be useful for people learning to write script. #!/usr/bin/ksh # # SCRIPT: 12_ways_to_parse.ksh.ksh # # # REV: 1.2.A # # PURPOSE: This script shows the different ways of reading # a file line by line. Again... (0 Replies)
Discussion started by: google
0 Replies
Login or Register to Ask a Question