Hi guys, for some months now (not sure which version introduced this) but if a user uses the return key in a comment field, the record wraps (starts a new line) in the CSV file when viewed in a text editor. This becomes an issue when importing this data into another database. I'm using bulk upload in SQL and it stops importing records where it hits the new line as it get's unexpected results. Hope I've made sense! The snip shows record 380 has wrapped twice. Any help would be greatly appreciated. This was never an issue in versions we were using over 6 months ago.
Hi @JonMarks,
Are you using the field app or web app to collect the data, and what version?
How are you exporting the data, from the Survey123 website or from ArcGIS Online? It sounds as if the fields in the CSV are not quoted correctly and the special characters are not getting nulled out and being treated as real line breaks.
Regards,
Phil.