5.6. Text Functions: LEFT_TEXT() and RIGHT_TEXT()

Data Transformation
Written By Siavash (Ahmad) Kanani

Just like in Google Sheets, LEFT_TEXT() & RIGHT_TEXT() are another text functions that allows us to extract a part of a text field according to the number of characters we indicate in the formula.

These text functions are valuable when grouping campaigns or other dimension categories.

Siavash (Ahmad) Kanani
Previous

5.7. Text Functions: REPLACE() and REGEXP_REPLACE()
Next

5.5. Text Functions: CONTAINS_TEXT(), STARTS_WITH(), and ENDS_WITH()