Passing A Parameter With An Apostrophe Or '&' Sign

[Chuckes]

I am having trouble passing parameters with an apostrophe or '&' sign.  Any suggestions on a work around for this.

[Jan]

Hello Chuckes,

 

I think, the best way to use internal parameters, if it works for you.

I mean, you can "pass on exit"  a parameter on the first DataPage - and "get on load" the parameter on the second DataPage, and set Destination for the first DataPage.

As far as I know, there is no problems with any signs in this case.

 

I hope, it helps.

[cheonsa]

Hi @Chuckes,

 

I found the same issue as yours. You may want to check this forum thread to resolve your problem.

 

 

Hope this helps.

 

Regards,

kristina

[Kurumi]

Hi! Just wanted to share this solution if you want to read or accept the single quote or apostrophe (') in the formula: https://stackoverflow.com/questions/9596652/how-to-escape-apostrophe-a-single-quote-in-mysql

Example:

Replace([@field:FIELDNAME], 'Can''t found the name', 'Remove name')