Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

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.