FileMaker
FM0-307 · Question #126
Given the following return-delimited data in a Team field of a FileMaker Pro 12 database: Andy Jones Bernie Lee Carry Lane Which formula would result in the string "Bernie Lee" (without quotes or…
The correct answer is B. Middle (Team ; 12 ; 10). See the full explanation below for the reasoning.
Question
Given the following return-delimited data in a Team field of a FileMaker Pro 12 database:
Andy Jones Bernie Lee Carry Lane Which formula would result in the string "Bernie Lee" (without quotes or leading/trailing carriage returns) from Team?
Options
- AListValues (Team ; 2)
- BMiddle (Team ; 12 ; 10)
- CGetltem (Team ; "¶" ; 2)
- DMiddleValues (Team ; 2 ; 1)
- ETrim (MiddleWords (Team ; 3 ; 4))
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- D4% (1)
- E8% (2)
Community Discussion
No community discussion yet for this question.