Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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..