Potential Problems with commas in the responses
-
I started having problems with the connector where my online form was working perfectly then all of a sudden the fields were offset to column O, and even though all the data was there, it did not match the columns. eg. The entered name was correct, but it wasn’t in the “name” column (column A).
I did massive testing on it and it seems like the characters aren’t being escaped properly. For example if the submitter uses a comma, their response it causes the offset. I was able to figure this out by testing, and on a failure, check the previous line and if it has commas for sure and maybe slashes, removed them. Then a retest worked perfectly. I only had 18 rows, so it didn’t take long to test this theory and prove it.
I tried to find documentation, but didn’t see it anywhere. Is this something I missed, or you can fix, or add an option to remove the unwanted characters?
The page I need help with: [log in to see the link]
- The topic ‘Potential Problems with commas in the responses’ is closed to new replies.