in reply to Re^2: Finding a specific value in another file
in thread Finding a specific value in another file

Yes, I guess you've got the idea: using a hash is by far the fastest (and also easiest) method, provided the data will fit into memory, which we know to be the case.

  • Comment on Re^3: Finding a specific value in another file

Replies are listed 'Best First'.
Creating generic format file
by rajiyengar (Initiate) on Jan 02, 2014 at 02:29 UTC
    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

      Hi,

      I'll try to understand and answer that question later, when I have more time, but I would suggest that you create a brand new post with your new question (possibly with a link to this thread), to get a chance that far more people can see your post and might answer it.