I have 2 files. I want to compare them. But the value format is different in both these files. For eg, one have value as 02000 and other have value as
2,000
Is there any way through which I can convert one format into other? I mean can we convert 02000 to 2,000 or vice versa so that I can match these 2 files through joinkeys?
Hi,
Is there any way through which I can convert one format into other? I mean can we convert 02000 to 2,000 or vice versa so that I can match these 2 files through joinkeys?
May be .. But not before you show us how both the input files look like,
sample record in both and what you want as output...
What is the record format and record lenght of both the input files...
your input files are confusing, first file was having a value of 20 10000 but in second file it is 20 1,000. Please provide us valid examples and specify the rules completely.
Shriram Jogdand,
You haven't mentioned your matching keys and based on your expected output (30 02400), you need to be matching on first 2 bytes only which doesn't need any conversion, unless you need conversion in the final output "after matching".
However, for either requirement,all these can be done in a single pass, you don't need 2 pass.I assumed you are trying to match on both the fields.