Hi again. I’ve noticed that whenever I export a form where there is ‘long text’ fields, quite often the result is that the rows of the CSV file get’s distrupted and data tend to move to other rows.
when i export a limited set of record fields (like navne, number, postal code) and leave out long text fields the CSV works fine.
This ‘problem’ is something i discovered after our campaign was over. I am on a tight time schedule and my boss are breathing down my neck on when he can get a report.
What can I do to get a proper export with all fields?
Seems like the export feature dont work well with Line Feed. I solved my problem by editing the export file in Notepad++ and replaced the Line Feed (\r\n) expression with blank.
.
