Question Re: Long string truncated on export to CSV in Technology Q&A

Long string truncated on export to CSV

Former Member — Thu, 15 Nov 2018 22:29:14 GMT

Using CR11.

I'm aware there's a string length limit of 65534 characters within CR, but I'm finding that when I export the report to CSV, long strings are getting truncated to approximately 32762 characters.

Is this expected behavior? Is there any way around this? Seems odd that the report allows a string of 65534 characters, but it get truncated on export.

Thanks!

Re: Long string truncated on export to CSV

former_member292966 — Thu, 15 Nov 2018 23:45:19 GMT

Hi Eric,

Are you opening the CSV in Excel? Excel has a limit of 32767 characters in a cell.

If you open the CSV in a Text Editor like Notepad++ you should be able to see the entire string.

Have a look at this thread.

https://superuser.com/questions/542927/increase-size-limit-of-data-import-from-csv-into-excel

Thanks,

Brian

Re: Long string truncated on export to CSV

former_member11696 — Fri, 16 Nov 2018 17:41:38 GMT

And if youa re using Crystal Reports 11.0 go here to get updated to CR 11.5, use your keycode for CR 11 to install 11.5 ( CR XI R2 )

Direct links:

http://downloads.businessobjects.com/akdlm/crystalreports/crxir2_sp4_full_bld_0-20008684.exe
http://downloads.businessobjects.com/akdlm/crystalreports/CRYSTALREPORTS06_0-20008684.EXE

Or pretty page with other updates available:

https://www.crystalreports.com/versions

Don

Re: Long string truncated on export to CSV

Former Member — Fri, 16 Nov 2018 21:10:12 GMT

Nope, I'm opening the file in Notepad++. The string is truncated in the exported text file.

Re: Long string truncated on export to CSV

Former Member — Fri, 16 Nov 2018 21:10:16 GMT

I am using Notepad++. I've tried exporting the data a number of different ways, and it always gets truncated.

Re: Long string truncated on export to CSV

Former Member — Mon, 19 Nov 2018 19:25:59 GMT

I double checked the version. It's 11.5.8.826.