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

CONTAINS_TEXT() function is useful when we are aggregating data based on different categories and we just want to use or present a keyword or a part of a string of text.

It gives out a Boolean expression (true/false). This function can help us prevent fractured categories (e.g., web traffic source)  into different rows.

Similar to CONTAINS_TEXT(), we have STARTS_WITH() and ENDS_WITH() functions which return a Boolean expression (true/false) when a dimension contains the value we’re searching for immediately at the beginning or immediately at the end of the text.

In this chapter:

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

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

→ 5.8. REGEXP_EXTRACT()

→ 5.9. REGEXP_MATCH()

→ 5.10. Every Chart is a Table

→ 5.11. Additional Resources

Enroll in the updated & extended Looker Studio Masterclass 2024 →

📩 Receive my weekly Looker Studio tips

🎥  Subscribe to my YouTube channel

🖇 Connect with me on LinkedIn