I have 2 files with a common parm - Jobname
File 1
File2
JOBA abcdefg server4
I would like to take each line from File1 and match the jobname with the jobname in File 2 and produce File 3 as
0507 1202 JOBA abcdefg server4
Could anyone help please, I'm new to scripting.
nawk 'NR == FNR{rec[$1] = $2" " $3; next}
{ print $0 " " rec[$3]}
' 64491_merge1.d 64491_merge.d
output
0507 1202 JOBA abcdefg server4
0507 1302 JOBB defghij server22
0507 1452 JOBC vwxyz12 server55
0507 1552 JOBA abcdefg server4
0507 1553 JOBA abcdefg server4
Brilliant Thanks very much indeed!
Another one:
awk 'NR==FNR{x[$1]=$0;next}$NF=x[$NF]' file2 file1
Having tested this on the simple files I provided it appears it doesn't work on the more complexed files. The first file has 6 field separated by blanks
File1
LVTS4687 LVTSHPLON ltreb_shu1l110 LVTS4687 LVTSHPLON shu1l110
The second file has 5 fields
and the result would need to look like
File3
this file comprises of field 1 2 3 4 5 of file2 and field 3 and 6 of file1
It seems quite easy, did you try to adapt the code yourself?
awk 'NR==FNR{_[$1]=$3 FS $6;next}$NF=$NF _[$3]' file1 file2>file3
Now your format is different then earlier
The output from this awk command is
Which is almost there apart from there being no space between parm5 and 6 and also parm 4 is reduced to the last 2 digits. Apologies for my ignorance on this but I have never used "awk" before. The file should look like this
0508 0601 LVTS4687 58 1 ltreb_shu1l110 shu1l110
Is it possible to format the file so each parm starts in a specific column for example
Parm1 in Col1
The first problem (the missing space) is trivial:
awk 'NR==FNR{_[$1]=$3 FS $6;next}$NF=$NF FS _[$3]' file1 file2
Could you be more specific?
Provide an example, please.
era
May 14, 2008, 6:39am
10
That sounds like a simple printf specifier.
awk whatever ... |
awk '{ printf ("%5s%6s%9s%5s%3s%35s%s\n", $1, $2, $3, $4, $5, $6, $7) }'
(Sorry, might have miscalculated the width of a few fields. Modifying the earlier script to do this is itself is probably not too hard either.)
I don't see anything which would be reducing $6 to just two characters.
The original file2 had the following
0508 2206 LVTS5431 98 1
but the output to file3 shows
where the 141 is truncated to 41
the final output I would like to see so that each parm is alligened in the specific columns
era
May 14, 2008, 8:58am
12
Whatever is causing that is not happening here, and it's unlear why it would be caused by Radoulov's script; it doesn't alter $6. Might your input file have been corrupted at some point?
Checked the file and you are correct the input file is wrong, so I think with the help of Radoulov and Era I've got there, many thanks indeed.
era
May 14, 2008, 9:43am
14
It's not showing as aligned any particular way here. Maybe if you post an example with code tags we can see better what you mean. (This regular HTML edit box will squeeze all spaces down to one.)
Its ok I just left aligned the printf and all looks good
awk '{ printf ("%-5s%-6s%-9s%-5s%-3s%-35s%-14s\n", $1, $2, $3, $4, $5, $6, $7) }'