Pulldata is not displaying data with ' in data. Basically, the pulldata is working for everything but when there is a single quote within the string (i.e. Cooper's Hawk), the data is not displayed. I tried using two single quotes (as is done in sql) and although that displayed the data, it then showed it with two single quotes. How do you correctly include ' in data displayed via pulldata?
Solved! Go to Solution.
The culprit was not in the same row at all, but some double-quotes elsewhere within the file. Once I replaced the double-quotes (") with nothing, it worked! Very odd. Regardless, that resolved the problem!
Hi Whitney,
I tried a sample with a single quote and it worked correctly. Can you look at the CSV file in a text editor and see if anything is unusual with that row?
The culprit was not in the same row at all, but some double-quotes elsewhere within the file. Once I replaced the double-quotes (") with nothing, it worked! Very odd. Regardless, that resolved the problem!
Are you only seeing this behavior in web forms?