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()