FileMaker
FM0-308 · Question #129
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 ; "-" ; "?quot; ); 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 ; "-" ; "?quot; ); 2)
- EMiddle (myText; Position (myText ; "-" ; 1 ; 1)+ 1 ; 4)
How the community answered
(35 responses)- A9% (3)
- B6% (2)
- C3% (1)
- D83% (29)
Community Discussion
No community discussion yet for this question.