Numbers in a text field

[#1]

I have an Invoice No field that is alphanumeric which has numbers in it. Sometimes the numbers are repeated but to make them unique a +sign has been entered at the end -

53160

53160+

53160-

Qlikview appears to drop the invoice number with the + at the end.

I have tried Text(Inv_No)  and left(Inv_No,10) and concating an A at the beginning of the field but having no luck.

Hope someone has some advice please.

[JaMajka1 · Accepted solution]

Is the problem already in QVD which is loaded or not?

[vishsaggi]

Can you check the field [INTERNAL NO] from you actual script. 

I mean what ever script you run just check after the reload what values you get for that field. Don't load from QVD.

[#4]

A selection script to preload our data has been written for us but when you prompted me to go to the tables directly I found the invoices all come  in correctly.

Sorry  so slow to answer but everything is new.

Thanks for your help.