Hi,
I am using Beyond Compare 3 to do a file compare and I’m having trouble getting the desired result. If the values in columns 16 – 30 are all 9’s, I want to compare the data in columns 1-94 and 100-301 on each record. If the values are not 9’s in columns 16 – 30, I want to compare the entire record.
My first thought is that I need to do 2 separate compares, 1 with the 9’s in column 16 - 30, and 1 without. So if I setup a Grammar, with the text matching 9’s, I can narrow the comparison down to those rows, but I’m having difficulty limiting the comparison criteria to Columns 1-94 and 100-301. I’m thinking I might need a regular expression to do it, but I’m hoping somebody can give me advice on how they would proceed. I’ve attached a small subset of each file for reference.
Thanks!
Mike
I am using Beyond Compare 3 to do a file compare and I’m having trouble getting the desired result. If the values in columns 16 – 30 are all 9’s, I want to compare the data in columns 1-94 and 100-301 on each record. If the values are not 9’s in columns 16 – 30, I want to compare the entire record.
My first thought is that I need to do 2 separate compares, 1 with the 9’s in column 16 - 30, and 1 without. So if I setup a Grammar, with the text matching 9’s, I can narrow the comparison down to those rows, but I’m having difficulty limiting the comparison criteria to Columns 1-94 and 100-301. I’m thinking I might need a regular expression to do it, but I’m hoping somebody can give me advice on how they would proceed. I’ve attached a small subset of each file for reference.
Thanks!
Mike
Comment