Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

LogicHelp

Hi guys,

I have one field in which values are

Field1

000234

.345

2356

9876

000012

Field 2

234

.345

2356

9876

12

Required Output

234

.345

2356

9876

12

Pls help

Regards

Abhay

7 Replies
pokassov
Specialist
Specialist

Evaluate?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Load all fields with

num(num#(DataField), '#.###', '.')

Not applicable

Finally the output is field2?

Kushal_Chawda

Simply do num(Field1)

or

purgechar(Field1,'0')

ashwanin
Specialist
Specialist

i think this is what you required.

ganeshreddy
Creator III
Creator III

Hi Abhay,

I think you need to apply purgechar logic which Kush has mentioned above. for reference go through attached file.

Cheers,

Ganesh

qlikviewwizard
Master II
Master II

Hi Abhay, did you able to manage to get the solution, please? Thank you.