in reply to Re^3: Finding a specific value in another file
in thread Finding a specific value in another file
Thanks a lot.
Now I want to take this to the next level. We get files from vendors in different format for a product and I want to transform them to one output format.
Output file:
Ocol1, Ocol2, Ocol3, Ocol4, Ocol5, Ocol6, Ocol7, Ocol8, Ocol9, Ocol10.
Vendor files:
Vendor1:
Vcol1, Vcol2, Vcol3, Vcol4, Vcol5, Vcol6
Source-target mapping:
Vcol1->Ocol1
Vcol3->Ocol2
Vcol4->Ocol4
Vcol5->Ocol8
Vendor2:
Vcol1, Vcol2, Vcol3, Vcol4, Vcol5, Vcol6, Vcol12, Vcol15
Source-target mapping:
Vcol1->Ocol12
Vcol3->Ocol2
Vcol4->Ocol15
Vcol5->Ocol8
I want to define input/output/source-target mapping in config files and want to write a generic perl program that reads the config files and generates output file.
In the case of shell script, I can create config files and include them in my script.
Would really appreciate some pointers here.
Thanks a lot
In Section
Seekers of Perl Wisdom