Shell Programming and Scripting

Hi,

sorry for the confusion. Below is another simple sample from my data:-

file1

file2
I bold the matched ids. the output should be all the data in file2 where the id (the first 5 char after "%") matches id in file1 as follows:

file3
in other words, i have huge data in file2 with multiple lines which could be continuous and separated by "\n". Therefore, i need to have a code that will print from the first char started by "%" and stop when it reaches the next "%", once the id matches with file1 ids. Thanks

Try : it works for input in#8

Code:

$ awk 'FNR == NR{A[$1]; next}/^\%/{f = (substr($1,2,6) in A) ? 1 : 0}f' file1 file2

%f07270 APSLH bl%alalalalallaadsdsfdfdfdgsgfsshhhhddddddddddhd234@678
dffffffffffgggggggggggggrrrrrrrrrrrrrwwwwww333r22356676dddddassfssfsfrdd
ujhjhkjkuuuuuuuuu2228888fddddddddddddddddererererer30
%q5548d alalalaaaaaaaaaaaaaaaa(aaaaaa)faagaaaaadddddddddddddd%68dd
ddddddddddddddd

Hi Akshay,

Your codes work perfect!!! Thanks so much...i don't understand some of them. can u pls explain the one that i color in red?

Code:

awk 'FNR == NR{A[$1]; next}/^\%/{f = (substr($1,2,6) in A) ? 1 : 0}f' file1 file2

thanks...

f = (substr($1,2,6) in A) ? 1 : 0 --> if 2nd char onwards, 6 six char from field 1 of file2 is found in array A of file 1 then, f will be set to 1 otherwise 0.

1--> true and,
0 --> false

whenever its true, that is f=1 it will print line.

Hi,

Got it.. thanks a lot!! )