NewExpression IN condition and escaping outer quotes
No rush for this, just logging
When setting NewExpression I can't successfully set an In array that INCLUDES START and END single quotes
Yes I appreciate 34 High Street should be enclosed in single quotes after the comma but i'm just using it to emphasize the 'Rose Cottage' part
ie If I set NewExpression to
In (Rose Cottage,34 High Street)
I get
In ('Rose Cottage','34 High Street') Correct
In ('Rose Cottage',34 High Street)
I get
In ('Rose Cottage','34 High Street') Not Correct
In (''Rose Cottage'',34 High Street)
I get
In ('''''Rose Cottage''''','34 High Street') Correct but not what I want
I want to give it this (or what should I give it)
In ('Rose Cottage',34 High Street)
and get this
In ('''Rose Cottage''',34 High Street)
You should type exactly "In ('''Rose Cottage''','34 High Street')" in the cell. Active Query Builder doesn't touch valid SQL expressions.