Beastmode with field names that have an apostrophe

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

  • Is anyone able to help out with this request?

     

    Thanks,

  • cwolman
    cwolman Contributor

    Would this work for you?

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


    -----------------
    Chris
  • ST_Superman
    ST_Superman Domo Employee

    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