AnsweredAssumed Answered

Find "from - until" not working properly when using "-" as separator in field

Question asked by lijnbach on May 7, 2014
Latest reply on May 10, 2014 by lijnbach

Summary

Find "from - until" not working properly when using "-" as separator in field

Product

FileMaker Pro

Version

13.0v3

Operating system version

Mac OSX as well as Windows 7

Description of the issue

I have a field with a separator. The field contains text values like "01-AA". If a find "from - until" is performed, the find result always loses the first in row.

So if I go to find and type "01-AA..02BB", the result is only "02-BB". If I type "01-AA..ZZ-99" I get them all, except 01-AA.

I found out that is only the case if the separator "-" is used.

See forum post:
http://forums.filemaker.com/posts/9c4ef820c7

Steps to reproduce the problem

See above

Expected result

Result should be "01-AA until 02-BB"

Actual result

02-BB

Exact text of any error message(s) that appear

No error messages

Workaround

Not yet a good one.

Outcomes