Search Results

If the two sample lines from your log files are as you have shown in past posts, the command line you specify above is equivalent to the command:
grep -e linkId=1ddoic abc-2012-10-01_000* | sort -u...

Looking at your command line, I assume that you need the count of 5th tab-separated columns from each line of test.txt matching the criteria specified by grep.

Just change your command line to:
...

First, the very last line sets the record separator variable (RS) to be either the greater-than or less-than symbol. That splits all of the input file into records based on either of those rather...

You could write a simple awk programme to extract the bits you need.


awk '
/^Val.*Db="[^"]+"/ {
gsub( "^Val ", "" );
gsub( "=\"", "<" );
gsub( "\" *", ">" );
...

This will print all the required sections on separate lines:
awk '/^<\?xml/ {while(match($0,/qry="[^"]*"/)){print substr($0,RSTART+5,RLENGTH-6);sub(/qry="[^"]*"/,"")}}' inputfile