Beastmode with field names that have an apostrophe

mrrm17
mrrm17
in Data Platform & Data Science

Hello,

I am having an issue with Campaign Names that have apostrophies in them, and also that their name conversions also need apostraphies. 

 

Unfortunately it seems the only way I know to indicate a text string is with '   '  that interupts the word.

 

Is there a way around this?

Comments

  • laura_igl
    laura_igl ⚪️

    Is anyone able to help out with this request?

     

    Thanks,

  • cwolman
    cwolman 🟠

    Would this work for you?

    replace(`field1`,'''','')


    -----------------
    Chris
  • ST_-Superman-_
    ST_-Superman-_ 🟤

    can you share the beastmode here?  

     

    Have you tried escaping the special character?  (i.e. 'America''s Campaign')  That is two single quotes in the name


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

Categories