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?
You are correct in your assessments. They are different, as Left() leaves the trailing space.
IDK if this was intentional, but they should be the same!