AnsweredAssumed Answered

Data Viewer misrepresents trailing returns

Question asked by LaRetta_1 on Jan 5, 2014
Latest reply on Jan 11, 2014 by indiguy


Data Viewer misrepresents trailing returns


FileMaker Pro


11, 12, 13

Operating system version

Mac OSX 10.9 (for testing) not tested on Windows

Description of the issue

As per screen shots, Data Viewer shows one carriage return from this calculation (in second image) and there are two.  We use Data Viewer to determine if the calculations we want to insert into our solutions will produce accurate results.  We DEPEND upon Data Viewer giving correct results.

Steps to reproduce the problem

Any calculation can be used but just type abc then carriage return into a field then drag-select from immediately after the last character downwards until the highlight ends.  That shows how many carriage returns exist.  In this example there would be one return but Data Viewer shows NONE in the Edit Expression Result.  It always drops one return.

Expected result

It should match the same results we would get when drag-selecting from all other venues.

Actual result

Misrepresents trailing returns

Exact text of any error message(s) that appear


Configuration information



It is normal to drag-select to see how many returns are at the end of ALL documents and data and that is what we do with Data Viewer as well.  Sure we can Select All and copy to text editor but I believe it is normal to expect drag-select to show trailing returns and work consistently like other venues in this regard.

This inconsistency is dangerous and can cause mistakes in calculation decisions and we simply must be able to trust the values being displayed in Data Viewer.

Thank you for your attention to this matter.

EDITED:  Changed number of returns displayed in the example, decreasing first example by one.