EXTRACTCHOICE("Based on the evidence, I must conclude that yes, he is guilty.") : TRUE
EXTRACTCHOICE("When I ask my son if he wants to eat broccoli, he screams NO!!!") : FALSE
EXTRACTCHOICE( text-to-extract-from )
text-to-extract-from (any textual)
A single Yes/No value reflecting the first occurrence of "yes", "no", "true", "or "false" in text-to-extract-from. Note that only a single value is returned, unlike the other EXTRACT() functions, which all return a list of values.