Importing Text: Result ends up longer than import

This is a pretty bizarre one... am importing in a transactional level data set which has a unique code for my list - model best practice fans.

Then as I load into one of the properties of the module some of the information transforms from a four digit character to the same four digits but with FIVE leading zeros. I've removed and then reloaded all to no avail - even reimporting the data source. And here's the thing, there are other four digit entries and this doesn't happen, loads up perfectly.

Any thoughts, any one?

Answers

  • Hi Andrew,

    Any particular reason you are importing into a text formatted line item and not a number formatted line item since the property is digits anyway?
  • Fair question... because other entries have letters in them.