Problems reading strings from dbf file

[#1]

Hi, Im trying to import data from a dbf file with the following text format: "000000"

But some values has less than six characters (for example "0040")

When qlikview import this field, fills with zeros to complete the six characters format and bring "000040".

Is there a way to keep the original format?

[Oleg_Troyansky]

have you tried using function text():

load

text(myField) as myTextField,

...

If you specify a format string "00000", you are asking QlikView to make all strings 6-characters long... Text() should do the trick for you.

Oleg

[#3]

Thanks for your answer.

I've tried the text( ) function and it works just fine.!

Greetings