5.1. Cleaning & Normalizing Data with Text Functions

A prerequisite to visualizing fields in text format inside Looker Studio is cleaning and normalizing text.

In the following lessons we will go over the basic functions and formulas we can use to clean and normalize our text data.

These functions are:

• CONCAT()
• LOWER() & UPPER()
• LENGTH()
• CONTAINS_TEXT()
• STARTS_WITH() & ENDS_WITH()
• LEFT_TEXT() & RIGHT_TEXT()
• REPLACE()
• RegEx Functions

Enroll in Looker Studio Masterclass →

📩 Receive my weekly Looker Studio tips

🖇 Connect with me on LinkedIn