How to extract information from a file?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to extract information from a file?
# 8  
Old 05-20-2014
Quote:
Originally Posted by Corona688
Something more like this, then:

Code:
$ cat iteration.awk

BEGIN { while((getline <bfile) > 0) D[$1]=1; RS="<"; FS=">" }

$1 == "Iteration_query-def" {   split($2, Q, " ");      if(D[Q[1]]) M=1 }
$1 == "Iteration" {     P=1     }
P { R=R"<"$0 }
$1 == "/Iteration" { if(M) print R;  M=P=R="" }
END { if(M) print R }

$ awk -v bfile="b" -f iteration.awk a.xml


Thanks a lot, i will try it
# 9  
Old 05-20-2014
Try worked with given sample :

Code:
awk ' 
      function dothis(){
			if(f){print s}
			s=f=""
		       }
      FNR==NR{
		gsub(/[[:space:]]+/,x,$1)
		A[$1]=1
		next
             }
           !f{
		split($2,S,/ /)
		gsub(/[[:space:]]+/,x,S[1])
             	f = (S[1] in A)
             }
             {
                s = s ? s ORS $0 : $0
		if(/<\/Iteration>/)
		 { 
			dothis()	
                 }
             }
	  END{ 
		dothis() 
	     } 
      ' FS=">"  fileB fileA

This User Gave Thanks to Akshay Hegde For This Post:
# 10  
Old 05-20-2014
Thanks!! It works perfect

Quote:
Originally Posted by Akshay Hegde
Try worked with given sample :

Code:
awk ' 
      function dothis(){
			if(f){print s}
			s=f=""
		       }
      FNR==NR{
		gsub(/[[:space:]]+/,x,$1)
		A[$1]=1
		next
             }
           !f{
		split($2,S,/ /)
		gsub(/[[:space:]]+/,x,S[1])
             	f = (S[1] in A)
             }
             {
                s = s ? s ORS $0 : $0
		if(/<\/Iteration>/)
		 { 
			dothis()	
                 }
             }
	  END{ 
		dothis() 
	     } 
      ' FS=">"  fileB fileA

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk script to extract transcript information from gff3 file

I need help to extract transcript information from gff3 file. Here is the input Chr01 JGI gene 82773 86941 . - . ID=Potri.001G000900;Name=Potri.001G000900 Chr01 JGI mRNA 82793 86530 . - . ID=PAC:27047814;Name=Potri.001G000900.1;pacid=27047814;longest=1;Parent=Potri.001G000900... (6 Replies)
Discussion started by: Maduranga
6 Replies

2. Shell Programming and Scripting

Extract information from file

In a particular directory, there can be 1000 files like below. filename is job901.ksh #!/bin/ksh cront -x << EOJ submit file=$PRODPATH/scripts/genReport.sh maxdelay=30 &node=xnode01 tname=job901 &pfile1=/prod/mldata/data/test1.dat ... (17 Replies)
Discussion started by: vedanta
17 Replies

3. Shell Programming and Scripting

Extract information from file

Gents, If is possible please help. I have a big file (example attached) which contends exactly same value in column, but from column 2 to 6 these values are diff. I will like to compile for all records all columns like the example attached in .csv format (output.rar ).. The last column in the... (11 Replies)
Discussion started by: jiam912
11 Replies

4. Shell Programming and Scripting

Extract information from txt file

Hello! I need help :) I have a file like this: AA BC FG RF TT GH DD FF HH (a few number of rows and three columns) and I want to put the letters of each column in a variable step by step in order to give them as input in another script. So I would like to obtain: for the 1° loop:... (11 Replies)
Discussion started by: edekP
11 Replies

5. Shell Programming and Scripting

Extract various information from a log file

Hye ShamRock If you can help me with this difficult task for me then it will save my day Logs : ================================================================================================================== ... (4 Replies)
Discussion started by: SilvesterJ
4 Replies

6. Shell Programming and Scripting

extract information from a log file (last days)

I'm still new to bash script , I have a log file and I want to extract the items within the last 5 days . and also within the last 10 hours the log file is like this : it has 14000 items started from march 2002 to january 2003 awk '{print $4}' < *.log |uniq -c|sort -g|tail -10 but... (14 Replies)
Discussion started by: matarsak
14 Replies

7. Shell Programming and Scripting

Create shell script to extract unique information from one file to a new file.

Hi to all, I got this content/pattern from file http.log.20110808.gz mail1 httpd: Account Notice: close igchung@abc.com 2011/8/7 7:37:36 0:00:03 0 0 1 mail1 httpd: Account Information: login sastria9@abc.com proxy sid=gFp4DLm5HnU mail1 httpd: Account Notice: close sastria9@abc.com... (16 Replies)
Discussion started by: Mr_47
16 Replies

8. Shell Programming and Scripting

Extract information from Log file formatted

Good evening! Trying to make a shell script to parse log file and show only required information. log file has 44 fields and alot of lines, each columns separated by ":". log file is like: first_1:3:4:5:6:1:3:4:5:something:notinterested second_2:3:4:3:4:2 first_1:3:4:6:6:7:8 I am interested... (3 Replies)
Discussion started by: dummie55
3 Replies

9. Shell Programming and Scripting

extract and format information from a file

Hi, Following is sample portion of the file; <JDBCConnectionPool DriverName="oracle.jdbc.OracleDriver" MaxCapacity="10" Name="MyApp_DevPool" PasswordEncrypted="{3DES}7tXFH69Xg1c=" Properties="user=MYAPP_ADMIN" ShrinkingEnabled="false" ... (12 Replies)
Discussion started by: sujoy101
12 Replies

10. Shell Programming and Scripting

How to extract a piece of information from a huge file

Hello All, I need some assistance to extract a piece of information from a huge file. The file is like this one : database information ccccccccccccccccc ccccccccccccccccc ccccccccccccccccc ccccccccccccccccc os information cccccccccccccccccc cccccccccccccccccc... (2 Replies)
Discussion started by: Marcor
2 Replies
Login or Register to Ask a Question