Hey AWK Folks!
I'm stumped... Here's what I'm trying to do. I have two files,
1) names.out with three fields space delimited. User Login ID,
Firstname, & Lastname IE:
jjd John Doe
jdd Jane Doe
sae Someone Else
... etc ...
2) masterfile.out with 3 fields colon delimited. User Login
ID:null:department number IE:
jjd:null:43
jdd:null:25
sae:null:9
... etc ...
What I need to do is fill all the null's in masterfile.out with first
and last name found in my names.out file. I would assume we would have
to open both files for read, compare the first field between the two
files and if the User Login ID matches, take fields $2 & $3 ( First
and Last name ) from names.out and copy to $2 of masterfile.out, if
the User Login ID does not match simply skip.
I have over 1,400 lines to go through for which only about 1,200
should match and fill the names in.
Is this something easy to do with awk? I've attempted many scripts but
I just can't wrap my head around this:(
Thanks for any help! :-)
Stephan
|
