Text calculations

Returns the categorical ordered intervals
BINS([Users Count]) use this sample
Returns provided date part of date as a text
DATENAME([Created On], 'year') use this sample
Returns first met value in a set
FIRST([Name]) use this sample
Returns first N symbols of text
LEFT('Hulk', 2) use this sample
Converts text to lower case.
LOWER('Hulk') use this sample
Replaces text to be replaced in an income text expression with its replacement
REPLACE([Name], 'Suit', 'Helmet') use this sample
Returns last N symbols of text
RIGHT('Hulk', 2) use this sample
Splits values of text field using defined delimiter.
SPLIT([Tags], ',') use this sample
Returns provided numerical or date as a text
TEXT([Created On]) use this sample
Combines all text values into one
TEXT_AGG([Feature]) use this sample
Converts text to upper case.
UPPER('Hulk') use this sample