Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Jordi,
As they are not numbers (because you are not going to operate with them) try the following in your loading script:
It will leave zeroes in the values.Text(Postal Code) AS Postal Code
Regards.
Hello Jordi,
As they are not numbers (because you are not going to operate with them) try the following in your loading script:
It will leave zeroes in the values.Text(Postal Code) AS Postal Code
Regards.