AnsweredAssumed Answered

Trying to search fields containing underscores with strings containing underscore yield unexpected...

Question asked by powella on Apr 1, 2011

Summary

Trying to search fields containing underscores with strings containing underscore yield unexpected results

Product

FileMaker Pro

Version

11.0v3

Operating system version

Windows 7, 32bit

Description of the issue

detailed in post:
http://forums.filemaker.com/posts/73669f3122
Basically FileMaker is treating a word containing an underscore as if that word were a quoted string with spaces instead of underscore when searching for greater than or less than values:

3_4 would be treated as "3 4"

Steps to reproduce the problem

Make a table with some values as such:
Na_Pa
Nb_Lit
Pa_Na

Try searching
>Na_Pa

Expected result

For the first search I would expect
Nb_Lit
Pa_Na

and an empty set for the second search

Actual result

either search returns a full set
Na_Pa
Nb_Lit
Pa_Na

Exact text of any error message(s) that appear

n/a

Configuration information

n/a

Outcomes