I'd like to request a couple of new options in the "Data Formats" section of the "Import Data File" wizard. These would be for String data items and both would be checkboxes.
The first would be "Remove Trailing Whitespace" and (as you'd expect) would remove trailing whitespace such as tabs or space characters from all String items. I frequently deal with string data items that are right-padded with unwanted spaces and it would be very handy to be able to remove these during the import rather than having to write a script to remove them later.
The second would be "Empty string as NULL" which when set would interpret an empty String item as NULL when inserting records into the database. This test should take place after the removal of trailing whitespace by the first option such that strings consisting of nothing but spaces may be interpreted as null.
Thanks for your consideration.
Thanks for your suggestions. I'll comment your suggestions point by point below.
Thanks for the heads up on the release notes. The entry was missing but has just been added.