Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
i am loading data from qvd to qlikview
my one filed XYZ
100
200
300
400
500
600
700
800
900
i need XYZ
100
200
300
400
500
600
700
800
Hi surik147,
If's because there are leading spaces in the field, you can use the TRIM functions to remoce them.
=ltrim(XYZ)
Hi,
Num(LTrim(XYZ)) as XYZ; If u have all Numbers.
Regards,
Khadeer
thank for uer reply
i am getting like th is if i use
100
200
300
400
500
600
700
thank for uer reply
i am getting like th is if i use
100
200
300
400
500
600
700
use
Num(trim(XYZ))
Hope this helps
thank for uer reply
xyz like 300,33H,123
hi
try like this
trim(subfield(xyz,','))
hpe it helps