Import without clear 0 on left

[#1]

Dear all,

i have a table that first column is a postal code (Fron diferrent countries, then lenght is variable)

I want to import to a table without clear chars 0 on left.

How can i do that

Example

Table 1

00080 -> imports 80 and I want 00080

00000080 -> Imports 80 and I want 00000080

Thanks for your help

[Miguel_Angel_Baeyens · Accepted solution]

Hello Jordi,

As they are not numbers (because you are not going to operate with them) try the following in your loading script:

Text(Postal Code) AS Postal Code

It will leave zeroes in the values.

Regards.