Shell Programming and Scripting

Hi,

I need help with the below scenario in Bash scripting:

I have two files:
tmp.orig with the below contents

Code:

"TEST1"
"TEST2"
"TEST5"
"TEST6"

and tmp.new with below contents

Code:

"TEST1;921"
"TEST2;34"
"TEST3;2"
"TEST4;33"
"TEST5;98"
"TEST6;1"

I need to run tmp.orig against tmp.new and match the characters while generating the below output:

Code:

"TEST1;921"
"TEST2;34"
"TEST5;98"
"TEST6;1"

I would greatly appreciate your help.
Note: Although the problem is real, these are dummy values and filenames.

Thanks.

This is pretty similar to the thread you posted in 2009: Matching key fields

What have you tried to solve this problem on your own?

What operating system are you using?

Yeah, that code is not going to work here. This is bash in Sun OS, and that was ksh in AIX.

I repeat: "What have you tried to solve this problem on your own?"

If i read the code in the mentioned other thread correctly the suggestion was to use

Code:

fgrep -f <file-with-keys> <file-to-search>

Which part of this is shell-dependent? Have you even read the other thread?

bakunin

The fgrep solution from that thread won't work exactly because the quotes in the files won't match properly.

There was also an awk suggestion in that thread. It won't work exactly either, but would be a good starting point if the field separators were modified.

I had just hoped that with our help in processing 41 requests over these last 7.5 years, ChicagoBlues would be willing to show us that some attempt had been made to come up with a solution for this relatively simple task before using the UNIX & Linux Forums as an unpaid programming staff. (However, I am disappointed at some of the suggestions that have been given to ChicagoBlues over the years.)

You are right and i perhaps should have done a better job of expressing myself. Regardless of the solution being usable as is or only after some tweaking

Code:

fgrep -f <file-with-keys> <file-to-search>

or any variation thereof will be independent of the shell employed. Therefore the mentioning


was about as astute as "yes, but it was mentioned on a Friday and today is Saturday".


Absolutely correct, but this (or any solution derived from it) would have nothing to do with the shell or the system - just with the willingness to undergo the effort to actually modify it into a fitting form.

Spot on on both accounts!

bakunin