Text comparison in FMP5
Hello,
I am using the = operator to check to text fields for being the
"same". As I run this, it appears that this comparison is not case
sensitive. Does that jibe with what others know?
aB5 appears to equal AB5
Thanks,
Bill
Re: Text comparison in FMP5
bjaynes [at] montanaport.net <bjaynes [at] montanaport.net> wrote:
> Hello,
> I am using the = operator to check to text fields for being the
> "same". As I run this, it appears that this comparison is not case
> sensitive. Does that jibe with what others know?
> aB5 appears to equal AB5
If you want an exact match, you can use the function "Exact(textfield1,
textfield2)" instead of the equals sign.
--
Hans Rijnbout
Utrecht, Netherlands
Re: Text comparison in FMP5
Thanks Hans,
Are you then saying that without applying "Exact", ab5 does equal AB5?
Bill
On Dec 1, 12:19 pm, jri... [at] xs4all.nl (Hans Rijnbout) wrote:
> bjay... [at] montanaport.net <bjay... [at] montanaport.net> wrote:
> > Hello,
> > I am using the = operator to check to text fields for being the
> > "same". As I run this, it appears that this comparison is not case
> > sensitive. Does that jibe with what others know?
> > aB5 appears to equal AB5
>
> If you want an exact match, you can use the function "Exact(textfield1,
> textfield2)" instead of the equals sign.
>
> --
> Hans Rijnbout
> Utrecht, Netherlands
Re: Text comparison in FMP5
bjaynes [at] montanaport.net <bjaynes [at] montanaport.net> wrote:
> Thanks Hans,
> Are you then saying that without applying "Exact", ab5 does equal AB5?
> Bill
Yes, as you found out. However, if in the field definition options under
"storage" you specify ASCII as the indexing language, you may change
this behavior.
> On Dec 1, 12:19 pm, jri... [at] xs4all.nl (Hans Rijnbout) wrote:
> > bjay... [at] montanaport.net <bjay... [at] montanaport.net> wrote:
> > > Hello,
> > > I am using the = operator to check to text fields for being the
> > > "same". As I run this, it appears that this comparison is not case
> > > sensitive. Does that jibe with what others know?
> > > aB5 appears to equal AB5
> >
> > If you want an exact match, you can use the function "Exact(textfield1,
> > textfield2)" instead of the equals sign.
--
Hans Rijnbout
Utrecht, Netherlands
Re: Text comparison in FMP5
Thanks Hans,
I appreciate your help with this.
Bill
On Dec 4, 4:57 pm, jri... [at] xs4all.nl (Hans Rijnbout) wrote:
> bjay... [at] montanaport.net <bjay... [at] montanaport.net> wrote:
> > Thanks Hans,
> > Are you then saying that without applying "Exact", ab5 does equal AB5?
> > Bill
>
> Yes, as you found out. However, if in the field definition options under
> "storage" you specify ASCII as the indexing language, you may change
> this behavior.