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 column | EXTRACT_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, ;)] |