How to display text with ' via pulldata?

451
3
Jump to solution
04-24-2019 07:30 AM
WhitneyWeber
Occasional Contributor

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?

0 Kudos
1 Solution

Accepted Solutions
WhitneyWeber
Occasional Contributor

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!

View solution in original post

0 Kudos
3 Replies
JamesTedrick
Esri Esteemed Contributor

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?

0 Kudos
WhitneyWeber
Occasional Contributor

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!

0 Kudos
DerrickWestoby1
New Contributor III

Are you only seeing this behavior in web forms? 

0 Kudos