Join our Community in its new Home - The Datorama Trailblazer Community Group!

It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.

We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at to keep the conversation going.

We can’t wait to see you there!

Harmonization Center - Patterns Help


  • MarissbcMarissbc New YorkSYS_ADMIN IMG42
    Hi @FrankCass10

    I am wondering if in this case it might be better to use a Calculated Dimension rather than the Harmonization Center. Within a Calculated Dimension, the EXTRACT function below can be used on text to only pull the text between a certain delimiter at a specific position:

    The Knowledge Base article here has some additional information!

    This would allow you to pull the piece of text based on one spot, anywhere from within the string.

    Would this work?!

Sign In or Register to comment.