Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
mkb_Qlik
Contributor III
Contributor III

Handling numeric values in String

Hello,

I have below scenario in Load script,

clipboard_image_0.png

 

If code1 holds any numeric value between 0-9 then code2 to be considered in my load script, how to do this in qlik scripting?.

 

Thanks in advance!

Labels (1)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

if(isnum(KeepChar(code1,'0123456789')),code2,code1) as NewField

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

if(isnum(KeepChar(code1,'0123456789')),code2,code1) as NewField
mkb_Qlik
Contributor III
Contributor III
Author

Thanks a lot Frank_Hartmann . It works well..