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.
Enjoying the free version of Looker Studio Masterclass 2022?
Join the new & updated Looker Studio Masterclass Live 2024 โ
๐ฉ Receive my weekly Looker Studio tips
๐ฅย Subscribe to my YouTube channel
๐ Connect with me on LinkedIn