Text Functions

If you are working with text in Datameer, then text functions help you determine information of the context of your text, such as seeing if the text contains certain words or characters, substituting strings with other strings, or returning a string as just lowercase letters.

These are the text functions in Datameer:

• CHAR
• CODE
• CONCAT
• CONTAINS
• CONTAINS_IC
• COUNTMATCHES
• COUNTTEXT
• ENDSWITH
• INDEX
• JSON_ELEMENT
• JSON_ELEMENTS
• JSON_KEYS
• JSON_MAP
• JSON_VALUE
• JSONARRAYSIZE
• JSONTOLIST
• LEFT
• LEN
• LOWER
• LTRIM
• MATCHES
• NGRAM
• NGRAM_OLD
• PROPER
• REGEX
• REGEXTRACT
• REPLACE
• REPLACEALL
• REPT
• RIGHT
• RTRIM
• SPLIT
• STARTSWITH
• SUBSTITUTEALL
• SUBSTITUTEFIRST
• SUBSTR
• T
• TOKENIZE
• TRIM
• UPPER