AnsweredAssumed Answered

Calculation Example Error in FileMaker's Help Website

Question asked by WF7A on Feb 21, 2018
Latest reply on Feb 22, 2018 by beverly

I'm just wondering if this is intentional or not: When you go online to FileMaker's website to look up examples for Position ( Position ) and Left ( Left ) where one of the examples extracts the first name, the examples are coded differently.

 

If you follow Left's example (at the bottom of the Web page), it's Left(Name;Position(Name;“ “;1;1))

 

If you follow Position's example (at the bottom of the Web page), it's Left(Name;Position(Name;“ “;1;1)-1)

 

In both examples you'll isolate the first name. However, if you use Left's definition then you'll be left with a word space after the resulting name; you don't have a wordspace when using Position's definition.

 

I know I'm being nitpicky (I'm a Database Admin, what can I say?), but shouldn't the examples be identical, favoring Position's definition?

Outcomes