Shell Programming and Scripting

Sorry Robin, i think i gave you incorrect examples...please find attached the corrected files...File4.txt to be looked up in File5.txt and the output should be like File6_Output.txt...

Thanks.

Hi Rudi....the code is working file in some cases...however please refer the attached...in few cases the value is not getting looked up...

Code:

Column 2 in File1.txt 

is looked up with Column 4 File2.txt

and the value of Column 4 is extracted in the output File3_Output.txt

However refer below mentioned line number are not being looked up for values

30492, 56681, 56686, 56704, 56705, 56706, 56707, 56712, 56713, 56714, 56718, 56756, 56761 and 64745..

Can you please chk and provide update...

Thanks

Your file seems to contain non-unix-like (windows?) chars, like <CR> (0x0D, <carriage return>, ^M), 0xAE, and &amp; - pls get the coding right. No surprise if certain fields don't match should different codings be used.
On top, you want to use <TAB> as the separator, but on quite some lines, two <TAB>s are used to separate apparently like fields.
Not sure I get your new requirement - which fields from which file should go to the output file? If you match field $2 with field $4, and then extract $4, why don't you stay with $2 in the first place?
In your output file, you seem to add the product name again to the end of the line, which makes it occur three times:

Code:

WH553-1 Whitehall John Deere Round Welcome One Line Standard Wall Plaque        n/a     2419JY  Light Industrial        Home Maintenance        Mailboxes        Whitehall John Deere Round Welcome One Line Standard Wall Plaque        Whitehall John Deere Round Welcome One Line Standard Wall Plaque

Please advise.

Hi Rudi,

Sorry for the late reply...i was stuck with something else...

the file you are looking at is for sample....we usually use vlookup to reconcile the data and find the differences....that's y u can see i am trying to lookup product name with a product name.....additionally Column 8 is being looked up manually in an excel file to verify whether the output that is getting generated with our code is in accordance with what we want...

yeah , you are write the file might contain some hidden control characters or windows character...can you please help me how to remove those and the run the lookup code to get the desired result...


thanks in advance for all ur help...