New Looker Studio Masterclass Live 2024 →

5.1. Clean & Normalize Data: Text Functions

🌐
The Most Complete and Advanced Looker Studio Training Course Online.

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
icon
Enjoying the free version of Looker Studio Masterclass 2022?
icon
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