Downloading List Contents - Data overrun into next Line version 10.2

asked on August 3, 2018

Hello,

I am having issues with downloading a CSV report from Laserfiche and I am hoping someone can help.

The problem seems to be when one of the Columns is a Multi-Value Field and the text contain a CR (Carriage Return), then where the CR is found, the text is placed on the next line in the CSV/XLS doc.

I have tried exporting as TAB or Comma delimited, but the results are the same. As a test I tried the Print Folder Contents option and printing it to a PDF file, and this does not seem to do the same. The text is kept together for that specific Column.

So I would like to know if there is a way around it or is this just the way it handles the exported data? It is causing a lot of clean-up to be done in the data once it is in the CSV.

Any help would be greatly appreciated.

Thanks,

Jennifer

0 0

replied on August 6, 2018

We are running 10.2.

replied on August 31, 2018

Sorry for the delay, i looked into this more and the behavior is by design according to the CSV file format. The value is enclosed in quotes, allowing the program reading the CSV to read everything until the trailing quote as part of the value. Excel is able to read the values. In the 10.3 client, the newlines are removed.

Question

Question

Downloading List Contents - Data overrun into next Line version 10.2

Replies

Sign in to reply to this post.