EXTRACTCHOICE()

Returns one Yes/No expression based on whether yes, true, no, or false appears first in a string as follows:

• TRUE if first occurrence in the text is yes or true.
• FALSE if first occurrence in the text is no or false.

Sample usage

EXTRACTCHOICE("Based on the evidence, I must conclude that yes, he is guilty.") returns TRUE 

EXTRACTCHOICE("When I ask my son if he wants to eat broccoli, he screams NO!!!") returns FALSE 

Syntax

EXTRACTCHOICE(text-to-extract-from)

• text-to-extract-from - Any textual value.

Notes

Returns a single value, unlike the other EXTRACT() functions which all return a list of values.

See also

EXTRACT()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDOMAINS()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()