Reply To: vLookup – SyntaxError: Invalid Character

Forums vLooup for SharePoint vLookup – SyntaxError: Invalid Character Reply To: vLookup – SyntaxError: Invalid Character


Thanks for the fast reply.
I’ve been doing some more testing of this, it looks like is it javascript/json escape characters causing the issue, but not quite as I was expecting.

A backslash on it’s own causes the error – it’s expecting a valid escape code because the backslash is there. Backslash followed by a non escape code character generates the error message and kills the vLookup.

A backslash as a valid escape code ( \n \r \\ etc) doesn’t error, and the whole string is then successfully used in the vlookup query.
For example; domain\rtester works as \r is a valid escape code.

I’ve attached some more screenshots to help illustrate. Firefox gives a slightly different error message to IE, specifically calling out a “bad escaped character”

Any ideas?