Certified Master Anaplanner

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?

2 REPLIES 2
Certified Master Anaplanner

Re: Importing Text: Result ends up longer than import

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?
Certified Master Anaplanner

Re: Importing Text: Result ends up longer than import

Fair question... because other entries have letters in them.