5.3. Text Functions: LOWER() & UPPER()

5.3. Text Functions: LOWER() & UPPER()

In cases where we have to deal with mixed-case dimension values, we can use the LOWER() and UPPER() text functions to set text to uppercase or lowercase.

These functions are useful for normalizing data, applying filters, and especially when dealing with case-sensitive functions.

In this chapter:

→ 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

Privacy Policy

Cookie Policy

Terms & Conditions

Website made by Notion & Super.so

@2023 Siavak Digital Marketing Kft. & Ahmad Kanani. All rights reserved. This website and its contents are independent of Google LLC, and are in no way affiliated, associated, authorized, endorsed by, or in any way officially connected with Google LLC, or any of its subsidiaries or its affiliates. The name ‘Looker Studio’ as well as the logo, related names, marks, and images are registered trademarks of Google LLC or their respectful owners. The use in this website and/or in related print or video material of trademarked names and images is strictly for educational, editorial, and descriptive purposes, and no commercial claim to their use, or suggestion of sponsorship or endorsement, is intended or made.