EXTRACT_SMILEYS

Syntax

EXTRACT_SMILEYS(<text>)

Description

Extracts emoticons from text and returns the results as a list.

Defined emoticons:

":)", ":-)", ":o)", ":]", ":3", ":>", "=]", "8)", "=)", ":}", ":')", ":-D", ":D", "8-D", "8D", "x-D", "xD", "X-D", "XD", "=D", "=3", ">:(", ">:[", ":(", ":-(", ":{", ":-[", ":<", ":'(", ";-)", ";)", ";]", ";D", ":-P", ":P", ":p", ":-p", ":|", ":/", ":\"

Examples

EXTRACT_SMILEYS(#Text_Column)

Text columnEXTRACT_SMILEYS returns
I love Datameer. :)[:)]
Big data is now not only something for scientists 8). Almost anyone =D can analyze large date sets with the correct tools. Of course, the best tool for the job is Datameer. ;)[8), =D, ;)]