topic Re: problem with parser in Operating System - HP-UX

problem with parser

amonamon — Tue, 10 Jun 2008 07:03:31 GMT

Hello..can anyone give me a clue how to get desired output:

file1:

5555:56:00 789 A
3345:56:18 189 B
1245:56:38 389 A
0045:56:58 689 S
0045:55:51 000 Q
1245:56:44 989 E
2245:56:11 089 E

file2
1245
0045

output:

1245:56:38 389 A
0045:56:58 689 S
0045:55:51 000 Q

I tryed something with comm and join command but I mess myself..

thank you guys

Re: problem with parser

amonamon — Tue, 10 Jun 2008 07:05:38 GMT

sorry output should be:

output:

1245:56:38 389 A
0045:56:58 689 S
0045:55:51 000 Q
1245:56:44 989 E

I forgot last line :)

Re: problem with parser

amonamon — Tue, 10 Jun 2008 07:18:01 GMT

again me...

I could do it this way...but takes a lot of time for my big files..

for file in $(< file2); do

grep $file file1 >> myoutout

done

any quicker way?

Re: problem with parser

Kenan Erdey — Tue, 10 Jun 2008 07:23:38 GMT

Hi,

Hope it helps:

awk '{system("grep "$0" file1")}' file2

Kenan.

Re: problem with parser

amonamon — Tue, 10 Jun 2008 08:37:31 GMT

kind of stupid...I put solutions for my problem..hahaah :))))

anyways anyone knows better way to optimise this:

join -1 1 -2 1 -t':' -o 2.1,2.2,2.3 file2 file1

thanks everyone.

Re: problem with parser

Dennis Handly — Tue, 10 Jun 2008 08:42:50 GMT

>but takes a lot of time for my big files..
>for file in $(< file2); do grep $file file1

You can do it in one shot:
fgrep -f file2 file1

This works if the strings in file2 don't appear in other columns of your data. If they do, you may have to add a "^" (and use grep) at the beginning of each line in file2.

Re: problem with parser

Dennis Handly — Tue, 10 Jun 2008 08:44:12 GMT

>I put solutions for my problem. hahaah :))))

Or you're telling us how to not do it. ;-)

Re: problem with parser

amonamon — Tue, 10 Jun 2008 09:45:56 GMT

kind of..:)

thank U very very much

Re: problem with parser

Hein van den Heuvel — Tue, 10 Jun 2008 10:52:02 GMT

Here is an other way to do it:

$ awk 'BEGIN{while (getline line<"file2"){file2[line]=1}} file2[substr($0,1,4)]' file1
1245:56:38 389 A
0045:56:58 689 S
0045:55:51 000 Q
1245:56:44 989 E

In the BEGIN section we read "file2" and set an array element with the key being the entire line to be true.

The main section consists of just a test for the array element in file2 identified by the first 4 characters in each line.

awk beginners might write that 'main' part as:
{ key = substr($0,1,4); if (file2[key]==1) { print } }

Cheers,
Hein.