What’s the switch?
What’s the problem?
A client of mine was gracious enough to do some testing with this switch and discovered a couple of notable issues.
- Leading zeros are stripped from string fields when they are exported to Excel.
- The last digit of a string field is changed from a ‘2’ to a ‘0’. For instance:
Without Enhanced switch:
Same record with Enhanced=TRUE
I am not sure if it matters that there were two zeros in a row, but for now the switch is not usable for these types of fields. Using only numeric fields it is wonderful, but for string fields it seems to have issues. Like Patrick reminded us, it’s ‘undocumented’ for a reason.
Until next post!