Chapter 5: Working with Text
In this chapter we will study another data modeling fundamental: Working with Text.
This is useful especially since half of the data we’re going to deal with are in text format, the other half being numbers.
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
→ 5.2. Text Functions: CONCAT()
→ 5.3. Text Functions: LOWER() & UPPER()
→ 5.4. Text Functions: LENGTH()
→ 5.5. Text Functions: CONTAINS_TEXT(), STARTS_WITH(), and ENDS_WITH()
→ 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
Next Steps:
💬 Questions? Get help from Looker Studio Community
🎓 Become Looker Studio Certified
📩 Receive my weekly Looker Studio tips
🎥 Subscribe to my YouTube channel
🖇 Connect with me on LinkedIn
🚀 Grow your agency or freelance practice
👨🏻💻 Private Consultation
5.1. Clean & Normalize Data: Text Functions
5.2. Text Functions: CONCAT()
5.3. Text Functions: LOWER() & UPPER()
5.4. Text Functions: LENGTH()
5.5. Text Functions: CONTAINS_TEXT(), STARTS_WITH(), and ENDS_WITH()
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