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 TSGal

(Moderator: I don't know whether it's proper to duplicate posts across threads, so feel free to delete this one (

Calculation Example Error in FileMaker's Help Website ) if you like.

 

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