I'm attempting to ignore the contents of a few columns in a text compare. I'm sure instructions are out here somewhere for this, but I can't seem to find them. Here's the file structure and a blurb on what I want to do...
File header:Address;ResultStatus1;ResultStatus2;ResultStatus3
File1: 100 Main St;606000606;60F000606;606000606
File2: 110 Main St;604000606;60E000606;605000606
I want to ignore any differences in the last three fields.
Thanks,
Matt
File header:Address;ResultStatus1;ResultStatus2;ResultStatus3
File1: 100 Main St;606000606;60F000606;606000606
File2: 110 Main St;604000606;60E000606;605000606
I want to ignore any differences in the last three fields.
Thanks,
Matt
Comment