5.6. Text Functions: LEFT_TEXT() and RIGHT_TEXT()

5.6. Text Functions: LEFT_TEXT() and RIGHT_TEXT()

Just like in Google Sheets, LEFT_TEXT() & RIGHT_TEXT() allows us to extract a part of a text field according to the number of characters we indicate in the formula.

These text functions are valuable when grouping campaigns or other dimension categories.

In this chapter:

→ 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.