4 Replies Latest reply on Oct 12, 2018 1:25 PM by Matthew Hefferon

    Regex Experts?

    Matthew Hefferon

      Hey Tableau Community!

       

      Any Regex experts out there? I have a string that I'm having trouble parsing. I was able to create a calculated field called "Get Key" That pulled out my key values successfully:

       

      Screen Shot 2018-10-12 at 9.42.48 AM.png

      I'm having issues with "Get Values".

       

      For the first record, I'm pulling Blue, Green, Red but I need Blue, Green, Red, Cat, Dog, Tesla.

      For the second record, I'm pulling Blue, Green, Red but I need Blue, Green, Red, Cat, Dog,

      The last record is working because there is only one value.

       

      I've attached a sample workbook. Any help would be much appreciated!

       

      Thanks