Excel File Comparison

Do you have anything to share with other users? Your opinions about our programs, suggestions for future products - everything goes here.
msis
Posts: 2
Joined: Mon Apr 07, 2008 6:29 pm

Excel File Comparison

Postby msis » Mon Apr 07, 2008 7:06 pm

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?

Image

Any help on this would be greatly appreciated.

grigsoft
Site Admin
Posts: 1671
Joined: Tue Sep 23, 2003 7:37 pm

Postby grigsoft » Tue Apr 08, 2008 4:00 am

Can you send me some files for testing?
Normally it should be so - CompareIt should be able to detect that line is moved.

msis
Posts: 2
Joined: Mon Apr 07, 2008 6:29 pm

Postby msis » Sat Apr 12, 2008 12:23 am

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
R1:FALSE
R2:TRUE
Files:*.xls
Use once:no
Action:Replace

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


Return to “General discussion”

Who is online

Users browsing this forum: No registered users and 2 guests