Emojis are pictographs most often seen in social media data sources, such as Twitter streams and Facebook posts. They may also appear in other data source types. As new emojis are developed, new encoding is used and sometimes this encoding cannot be processed by Klipfolio. The REMOVE_EMOJI function is used to strip emojis from selected data so the remaining data can be processed. If the selected data does not contain emojis, the REMOVE_EMOJI function returns the selected data as is.
The syntax for the REMOVE_EMOJI function is:
REMOVE_EMOJI ( text )
|text||The text field containing the emoji icons||vector|
Where text and screen_name point to the /text and /user/screen_name fields in a Twitter data source.
- To display Twitter tweets which may contain emojis:
REMOVE_EMOJI( text )
- To select specific Twitter tweets which may contain emojis:
SELECT( REMOVE_EMOJI( text ), ( screen_name = Klipfolio ) )
Where message and name point to the /data/message and /data/from/name fields in a Facebook data source.
- To display Facebook posts which may contain emojis:
REMOVE_EMOJI( message )
- To select specific Facebook posts which may contain emojis:
SELECT( REMOVE_EMOJI( message ), ( name = Klipfolio ) )