FileMaker
FM0-307 · Question #180
Given a text field myText that contains "red-blue-green", which two formulas could be used to extract the word "blue" from the field? (Choose two.)
The correct answer is D. GetValue (Substitute { myText ; "-" ; "¶" ); 2) E. Middle (myText; Position (myText ; "-" ; 1 ; 1)+ 1 ; 4). See the full explanation below for the reasoning.
Question
Given a text field myText that contains "red-blue-green", which two formulas could be used to extract the word "blue" from the field? (Choose two.)
Options
- AFilter (myText ; "blue")
- BMiddleWords (myText; 2 ; 2)
- CPatternMatch (myText ; "blue")
- DGetValue (Substitute { myText ; "-" ; "¶" ); 2)
- EMiddle (myText; Position (myText ; "-" ; 1 ; 1)+ 1 ; 4)
How the community answered
(45 responses)- A4% (2)
- B16% (7)
- C7% (3)
- D73% (33)
Community Discussion
No community discussion yet for this question.