FileMaker
FM0-308 · Question #25
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" )
- BMiddleValues ( myText ; 2 ; 1
- CPatternMatch ( myText ; "blue"
- DGetValue ( Substitute ( myText ;"_"; "?) ; 2)
- EMiddle ( myText ; Position ( myText "-" ; 1 ; 1 )+ 1 ; 4)
How the community answered
(29 responses)- A3% (1)
- B10% (3)
- C3% (1)
- D83% (24)
Community Discussion
No community discussion yet for this question.