I'm attempting to use the pulldata function in survey123 connect to get road information, I need to get the street name and use that in a future sql clause. I'm having the issue that street names with an apostrophe break the sql clause, it works fine with street names without any special characters.
This the statement:
pulldata("@layer","getValue","attributes.Total",${RoadQu}, concat("DISPLAYNAM='", ${RdName},"'"))
I've also tried this to no avail.
pulldata("@layer","getValue","attributes.Total",${RoadQu}, concat('DISPLAYNAM="', ${RdName},'"'))
thanks
