Comparison omit line breaks

[cjkeller]

Is there a way to set the comparison settings so it will not check for line feeds/breaks?

I have one field in my table that will match in everything but in the number of line breaks at the end of the data in the field or through out the data. I don't care if there are three line breaks in one field versus one line break in the same field in the databases I am comparing.

I looked under Options under Edit Comparisons and didn't find one that did that.

Thanks.

Christy

[alexa]

You would need to select the 'Ignore trailing spaces' option on the 'Options' page of the New Data Comparison wizard.