Page 1 of 1

Excel File Comparison

Posted: Mon Apr 07, 2008 7:06 pm
by msis
Hello All,

When comparing Excel Files, I keep coming up with "False" line matching. I have gone to the Help Menu - "In rare cases, the comparison engine can do false line matching. This can happen if a file has multiple duplicate lines. To correct this problem, you can perform manual matching." I am unable to get the manual matching to work for me. Is there any way to ignore these type of differences?


Any help on this would be greatly appreciated.

Posted: Tue Apr 08, 2008 4:00 am
by grigsoft
Can you send me some files for testing?
Normally it should be so - CompareIt should be able to detect that line is moved.

Posted: Sat Apr 12, 2008 12:23 am
by msis
Thank you for all the help. Using the regular expressions worked for us....
If all you want is to ignore that TRUE\FALSE difference,you can do it with Regular Expression support. Open Options>Comparison,select "Use regular expressions" check, and press '..' button next to it.Create new expression with following parameters:

Name: ignore false
Use once:no

This will consider that FALSE equals TRUE during comparison. You may add additional blanks to avoid wrong matches: " FALSE " (without quotes).