Shell Programming and Scripting

Hi Everyone,

Seeking for your assistance on how to bash the file 1 to file 2 records and output the same records with specific field to display to file3.

Example: Imagine we have many Files and records in File 1 and the File2 is only 1 file but many records.

File1

Code:

A<tab>B<tab>C<tab>D<tab>E

File2

Code:

E<tab>F<tab>C<tab>G<tab>H

Expected Output:

Code:

A<tab>B<tab>C

Since the 3rd field "C" is the same in file 1 and file 2 it will output only the 3 fields into File3

I'm trying to use the awk to display the 1,2,3 Field but i don't know how to bash the file1 and file2 i think it will require loop

Code:

awk -F "\t" '{print $1}'
awk -F "\t" '{print $2}'
awk -F "\t" '{print $3}'

Please advise,

Thanks,
-nik

Moderator's Comments:

Please use CODE tags when displaying sample input and output as well as code.

Are you looking for a bash solution or an awk solution? The standard approach with awk is to use a NR==FNR construct. You can use that as a search term on these forums. You will find many examples..

Is this a homework assignment?

If not, what do you mean by the text marked in red above? You have shown us two sample input files that each only contain 1 line (or record). Obviously a file can contain many lines. But for a file to contain many files, that file is either a directory or an archive file of some type. You need to much more clearly explain what you mean by this and give us a much better example.

If there are multiple lines in files 1 and 2, are lines from file 1 supposed to be copied to file3 if the 3rd field on any line in file 2 matches the 3rd field on a line in file1? Or is a line from file 1 only supposed to be copied to file3 if the 3rd field on the line in file2 matches the 3rd field for the corresponding line (for example, line 1 in both files or line 5 in both files) in file 1?

Sorry Moderator T_T.

Hi Sir Scrutinizer,

Sorry i'm still a newbie, but can you give me sample of NR==FNR?

Please advise,

Thanks,

---------- Post updated at 06:07 PM ---------- Previous update was at 06:01 PM ----------

Sorry Sir Don Cragun.

Sorry Sir It's not an Assignment. I just don't have any idea on how to solve it. Thanks Everyone for the support.

BR,