How do I deal with apostrophe in user name while passing variable to JavaScript?

Question

I pass a variable of Current User to a javascript page. It works fine unless the name includes an apostrophe (O'Neil).

The formula includes: "var Cuser = '" & URLEncode(User()) & "';" &

How would I change this to not error out if name includes an apostrophe?

BTW the error if user name has an apostrophe is : SCRIPT1004: Expected ';'

Thanks

MCFNeil · Answer

Try making any of these adjustments to your variable definitions.http://stackoverflow.com/questions/19399610/passing-a-parameter-to-function-with-single-quote

Sign up

Login to the community