Shell Programming and Scripting

Hi All,

I am in a situation wherein I have one look-up file or say mapping file which has two columns of data , suppose:

LookupFile.txt:
col1 col2
6589 7879
8787 0909
4343 4576

Now in the file which has to be processed has following format:

to_be_processed_file.txt
col1 col2 col3
676787989800996589 65656576687878
788757657675768787 88787878756446
323247656876984343 42341242542345

Now suppose in row 1 I need to append 6589 with respective value from mapping file i.e 7879. Similarly 8787 should be replaced as 0909.
The new value should fill the space in the col2:
So after processing it should look like this:

col1 col2 col3
6767879898009965897879 65656576687878
7887576576757687870909 88787878756446
3232476568769843434576 42341242542345

Kindly Help !

are all the value in column1 of 'LookupFile.txt' of the same 4-character length OR can they all be of different length?

given a 4-character lookup key in the 'LookupFile.txt' file...
nawk -f rahul.awk LookupFile.txt to_be_processed_file.txt

rahul.awk:

Code:

FNR==NR {f1[$1]=$2; next}
{
  s=substr($1, length($1)-3)
  if ( s in f1)
     $1 = $1 f1[s]
}
1

lookup key is of length 10 and it does not vary , will this work then ?

Code:

FNR==NR {f1[$1]=$2; next}
{
  s=substr($1, length($1)-9)
  if ( s in f1)
     $1 = $1 f1[s]
}
1

If tried getting character 28 to 37 from column:
s= substr($1,28,10)
This didn't work:
As I need to replace character 28to 37 in first column with value from mapping file.
Plz help !

this is different requirement with no sample input and desired output - replacing is not the same as 'suffixing' .pls provide both