10 Replies Latest reply: Oct 14, 2014 3:54 PM by Srikanth P RSS

    mask or wrap single quotes

    Marcus Sommer



      are there possibilities to mask single quotes or wrap it within other quotes?


      By variables I could use: set var = "categorie = 'abc'"; and within the load a call like if($(var), 1,0) as XYZ but if I call a sub-routine with such a parameter: call subXYZ(var) it didn't work.


      All variants of masking or wrapping I have tried are failed like wrapping with 2/3/4 single/double quotes or brackets or grave accents ...


      Of course I could build a concat string and use chr(39) instead of single-quotes or could use a dummy-char which I later replace but this are unwanted workarounds.


      Any ideas? Many thanks!


      - Marcus