Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

String compare in multiple files

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting String compare in multiple files
# 8  
Old 11-13-2009
Please provide a better example of the file.
How do you recognize the last item? There are a lot of tags with "</_:RequestStructure>".
# 9  
Old 11-13-2009
Looking at your last example where you expect 9 items it would seem you could simply look for any item end tags between: -

Code:
<_:RequestStructure>

and

Code:
</_:RequestStructure>

# 10  
Old 11-13-2009
ofcourse you could do that but there are other audit entries like
#####====> AUD99 - ACTION
<_:RequestStructure>
</item>
</item>
</item>
</_:RequestStructure>

but I am intrested only

#####====> AUD57 - ACTION
<_:RequestStructure>
</item>
</item>
</item>
</_:RequestStructure>
# 11  
Old 11-16-2009
Try this:

Code:
awk '
/AUD57/{f=1} 
/<\/ITEM>/ && f {c++}
/AUD/ && !/AUD57/{print "Number of occurrence: "c; exit}
' file

Output:

Code:
$ cat file
#####====> AUD57 - ACTION
<_:RequestStructure>
        </ITEM>
        </ITEM>
        </ITEM>
</_:RequestStructure>

#####====> AUD57 - ACTION
<_:RequestStructure>
        </ITEM>
        </ITEM>
        </ITEM>
</_:RequestStructure>

#####====> AUD57 - ACTION
        </ITEM>
        </ITEM>
        </ITEM>
</_:RequestStructure>

#####====> AUD58 - ACTION
<_:RequestStructure>
        </ITEM>
        </ITEM>
        </ITEM>
</_:RequestStructure>
#####====> AUD67 - ACTION
<_:RequestStructure>
        </ITEM>
        </ITEM>
        </ITEM>
</_:RequestStructure>
$
$ awk '
/AUD57/{f=1} 
/<\/ITEM>/ && f {c++}
/AUD/ && !/AUD57/{print "Number of occurrence: "c; exit}
' file
Number of occurrence: 9
$
$

# 12  
Old 11-16-2009
Frank

Thanks a lot for the time and effort. That would work exactly if the input log file looks like that. but as I said earlier the <item> can be random in between and some are not even inside a "AUDxx" block.

In the example log if you have an <item> floating (with out having proper AUD and Requeststructure then the script would result 10 - wouldnt? . And that's the problem for me. Sorry I know this is getting longer.

I start thinking to write a java program to sort this out as I have very little time left on this.

much appreciated - great help
-arun
# 13  
Old 11-16-2009
Ok, one more try:

Code:
awk '
/AUD57/{f=1} 
/<\/item>/ && f {c++}
f && /<\/_:RequestStructure>/{f=0}
END{print "Number of occurrence: "c}
' file

# 14  
Old 11-16-2009
That seems working - great. Thanks a lot for the help and much appreciated your time on this.

Great.

-arun
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Two files String compare

file1.txt col1 col2 col3 b100:07-24-2018:test1 b102:04-24-2017:test2 b103:04-24-2017:test3 b104:04-24-2017:test3 file2.txt col4 col5 b100:name1@email.com b102:name2@email.com b103:name3@email.com Comparing string from file1.txt(col1) each record with... (3 Replies)
Discussion started by: ramgk5
3 Replies

2. Shell Programming and Scripting

How to compare multiple files in UNIX?

Hi, I have below query related to multiple file comparing I have four files i want to compare it and contents of one file will not be presence in 3other files and if any content found then it will print the execution. Can you please help me how to achieve it. (2 Replies)
Discussion started by: soumyamihp
2 Replies

3. Shell Programming and Scripting

Compare the string in different files

Hi, There is a file A.txt which contains a list of strings. A.txt QASSBRK1 QASSBRK2 And in B.txt, command is written to generate output of dspmq with AWK script B.txt QMGR=`dspmq | awk '{print $1}' | cut -f2 -d "(" | cut -f1 -d ")"` Output of B.txt is QASSBRK1 QASSBRK2 QASSBRK3... (4 Replies)
Discussion started by: Anusha M
4 Replies

4. Shell Programming and Scripting

Compare columns of multiple files and print those unique string from File1 in an output file.

Hi, I have multiple files that each contain one column of strings: File1: 123abc 456def 789ghi File2: 123abc 456def 891jkl File3: 234mno 123abc 456def In total I have 25 of these type of file. (5 Replies)
Discussion started by: owwow14
5 Replies

5. Shell Programming and Scripting

Compare multiple files, and extract items that are common to ALL files only

I have this code awk 'NR==FNR{a=$1;next} a' file1 file2 which does what I need it to do, but for only two files. I want to make it so that I can have multiple files (for example 30) and the code will return only the items that are in every single one of those files and ignore the ones... (7 Replies)
Discussion started by: castrojc
7 Replies

6. Shell Programming and Scripting

Compare multiple columns from 2 files

Hi, I need to compare multiple columns from 2 files. I can, for example, have these 2 files: file1: col1, col2, col3,col4 a,1,4,7 b,2,5,8 c,3,6,9file2: col1, col2, col3,col4 a,2,3,2 b,5,7,5 c,1,9,8As a result, I need for example the difference between the columns 2 and 4: col2,... (3 Replies)
Discussion started by: Subbeh
3 Replies

7. Shell Programming and Scripting

Compare multiple files with multiple number of columns

Hi, input file1 abcd 123 198 xyz1:0909090-0909091 ghij 234 999 xyz2:987654:987655 kilo 7890 7990 xyz3:12345-12357 prem 9 112 xyz5:97-1134 input file2 abcd 123 198 xyz1:0909090-0909091 -9.122 0 abed 88 98 xyz1:98989-090808 -1.234 1.345 ghij 234 999 xyz2:987654:987655 -10.87090909 5... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

8. Shell Programming and Scripting

Script to find & replace a multiple lines string across multiple php files and subdirectories

Hey guys. I know pratically 0 about Linux, so could anyone please give me instructions on how to accomplish this ? The distro is RedHat 4.1.2 and i need to find and replace a multiple lines string in several php files across subdirectories. So lets say im at root/dir1/dir2/ , when i execute... (12 Replies)
Discussion started by: spfc_dmt
12 Replies

9. Shell Programming and Scripting

compare multiple files and get the difference

Hi all, i have 50 files .data should be same in these 50 files , so my task is to find the difference. i need a logic , which finds difference between all files and print in output file with file name where it found that difference . i tried below logic , but its not giving me what i want. let... (2 Replies)
Discussion started by: deepakiniimt
2 Replies

10. Shell Programming and Scripting

compare string in two files

i have two files: file1.txt AA BB DD EE file2.txt AA,AAA BB,BBB CC,CCC DD,DDD EE,EEE FF,FFF i want an output file: file3.txt AA,AAA BB,BBB (2 Replies)
Discussion started by: MiLKTea
2 Replies
Login or Register to Ask a Question