Line Breaks in export Customer record in Csv format.

ManiNav

Hi Everyone,

I am exporting some fields of Customer in Csv format via running report.For some Customer, records are breaking the line.

This is the code , I am using to export in report.
Customer- OnAfterGetRecord()



For almost all Customer record is coming correct but for some customer, record is breaking the line:
I attached the sample screenshot for refence:



Please suggest me the further step or tell me, where I am doing mistake.

Thanks,
Mani.

ManiNav

Hi,

I resolved the issue to follow this link:
http://navnilesh.blogspot.com/2015/01/hi-in-nav-there-is-often-issue-with.html

Thanks,
Mani.

vaprog

Hi,

line break is in your data. Either convert your data, or quote the field (if the consumer does understand quoted fields with line breaks (Excel does, NAV (most likely) does not)).

ManiNav

Hi,

I resolved the issue to follow this link:
http://navnilesh.blogspot.com/2015/01/hi-in-nav-there-is-often-issue-with.html

Thanks,
Mani.