I have 2 VB input files.
The above are 2 input files. I need some data from file1 and some data from file2. Key is 111, 22 and 3333 are these are common in both the files. As these files are Comma delimited we don't know exactly the length of each field, so we cannot use FIXLENGTH while Parsing.
Could you please let me know how can we do this using sort. Lets say the records are in sorted order.