Question Re: Space issue while exporting in CSV Archive format in Technology Q&A

Space issue while exporting in CSV Archive format

former_member1186904 — Tue, 30 Aug 2022 04:17:51 GMT

Hi,

I am facing a space issue while exporting the report in CSV Archive format. When I export a report in CSV Archive format and opened it with a text editor it's showing a space in beginning of the cell for a particular text field in GTU environment.

But the same report same field didn't show any space at the beginning when I exported the report and opened it with Text editor in RU Environment. Let me know how to resolve this issue.

Re: Space issue while exporting in CSV Archive format

nscheaffer — Tue, 30 Aug 2022 13:53:40 GMT

Is the object corresponding to the cell with the extra space being trimmed in the report? Keep in mind any formatting, calculations, etc. done in the report will not be reflected in the CSV export. Perhaps there actually is an extra space at the beginning of the value in that column. Can you run the generated query directly against your database to check that?

Noel