I have the following files, is there anything I can do to match using icetool? Ideally I would like a file of those items that match, and those that don't, so I can then do some other processing on these items. From file 2, I'm trying to obtain the 'P' number in position 37,12 for each item in file 1 that I can find in file 2.
File 1 - (18 digit account, plus 12 digit reference)
File 2 - (18 digit account, plus 18 digit reference)
File 1 has around 100,000 items which I need to match with around 1 million items in file 2. The problem is in file 1, only 12 characters of the 18 reference are held (pos 13-18 are spaces), whereas in file 2, the full 18 characters are held.
File 1 -001500753000086796ABWORLD 1234
File 2- 001500753000086796ABWORLD 1234562518P00000016102
Many of the items in file 1 will have a reference of 12 characters or less, so it will be possible to get a match. It is also possible that there may be more than 1 match.
Is there any way of generating some sort of match for the items where the reference is 12 characters or less, and putting the unmatched items in a seperate file for further processing?