Create Beast Mode Calculated Field from sub-string in Placement separated by multiple delimiters



I need to select a substring from our Placement Names that returns the Creative Name that is nested within the Placement Name. The characters within the Placement Names and Creative Names vary, so I need MySQL code that works in BeastMode that concatenates all characters between the -3 underscore and the -2 underscore. Can someone please help with this?



Placement Name

Partner_CampaignType_CreativeType_Targeting_CampaignName_OperatingSystem__CreativeSize_CreativeName_12345678_Pixel (1234567891234) 


Desired Result



  • I really wanted to learn how to do this with the regex function in the ETL dataflow.  However, I am not any good at regex so I gave up.


    Here is a solution for this with a MySQL select statement:1.png



    I will paste the code here so you can copy and paste...


    `Placement Name`
    ,SUBSTRING_INDEX(`part1`, '_',1) as `output`
    `Placement Name`
    ,SUBSTRING_INDEX(`Placement Name`,'_',-3) as `part1`
    reg_exp_help) a

    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman