
Contributor III
‎2019-10-02
06:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Handling numeric values in String
Hello,
I have below scenario in Load script,
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!
- Tags:
- qlik sense app
787 Views
1 Solution
Accepted Solutions

Master II
‎2019-10-02
06:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if(isnum(KeepChar(code1,'0123456789')),code2,code1) as NewField
781 Views
2 Replies

Master II
‎2019-10-02
06:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if(isnum(KeepChar(code1,'0123456789')),code2,code1) as NewField
782 Views

Contributor III
‎2019-10-02
06:55 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot Frank_Hartmann . It works well..
771 Views
