How to NOT print the ASCII Char(160) Trailing Space at the End of Character Fields

There is a trailing space that will print in any data field that is text based, when AGRIS prints a report to a spreadsheet with headers.
This trailing space is a non-printable ASCII character 160. You do not see it on your spreadsheet but you do see the effects of it.
For example, a field like NAME ID NUMBER is a character field in AGRIS.
The data is saved as 00010 but Excel opens it as 10 if you do not have the Char(160) trailing space to make Excel realize it is a text field, not a numeric field.

You can use formatting and fine/replace functions to remove these.

Removing Trailing Space from Fields in Excel

But there is a hidden feature in Report Writer that will create reports without this Char(160) character.

The "hidden option" to prevent the special character from being placed on the csv values is to set the Zero Fill Numerics = Yes

The assumption is that if you are zero-filling the numeric fields, then you're not loading it up into Excel, because that would just strip off the leading zeros again from the numeric fields.

So if you're zero filling numeric fields, and you're not loading into Excel, then there is no reason for the system to place the hidden character at the end of the character fields - because that's an excel only reason for doing that.

WARNING: this means that if you open the file in Excel, it will DROP LEADING ZERO’S, so that the data no longer matches what is saved in AGRIS.