Awk or Gawk expert to do data manipulation

This might be a long term relationship. I already spent more than $2000 on programming and I still have more works. So once this project turns out successful, then I can give you more and more projects.

But let's start from the following mini-project.

Important: Set your bid price as if your bid is to solve the following mini-project. I think it's less than $20 because I heard from a programmer that this can be done by only few lines using gawk.

But again, once this project turns out successful, then I can give you more and more projects.

-----------------------------------------

I will explain by example.

I want to specify to the program things like the following.

input file = [url removed, login to view]

match file = [url removed, login to view]

output file = [url removed, login to view]

column of input file to match = (1,2)

column of match file to match = (4,2)

(col of match) => (col of output) = (3=>2), (2=>3)

Then, if

File A looks like

a 3 5

3 a 4

b 7 3

7 b h

f f k

File B looks like

2 a rt 3

3 b 3 7

4 f 2 4

(1,2) of A and (4,2) of B matches 2nd and 4th rows. So only in these rows, "(col of match) => (col of output) = (3=>2), (2=>3)"

So [url removed, login to view] should be

a 3 5

3 rt a

b 7 3

7 3 b

f f k

Procesamiento de datos

Nº del proyecto: #4814460

Sobre el proyecto