While editing data (submitted via Survey123) in ArcDesktop the other day, we noticed that information was missing in some of the text fields. But then realized it was there, but not visible because it had been entered with a <return> on the ipad.
Here's what it looks like in the attribute table:
When selected during an editing session, the additional text (after the break) is revealed:
Further investigation revealed that the note was entered in S123 like so:
Intensive
FB-7:18
Is there a way to prevent this? Maybe a way to convert the <return> to a "space" when the survey is submitted?
Please advise, thanks!
Lynn
Hi Lynn,
That was a separate issue caused by the same character- in that case, the report template was ignoring the carriage returns. That has been fixed since the post.
What about using not(regex(., '\n')) in the constraint column? This should prevent anyone from submitting the survey if there are carriage returns in the question(s). Just be sure to add a very clear constraint message!
Using an update cursor seems to do the trick. See my comment posted 2/11/19 https://community.esri.com/thread/228309-where-clause-for-n