Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Substring question

Hello , 

Is it possible to know how to extract a sub string in a new field for the following scenario :   

The content of my field is only numeric or numeric following by alphabetical  characters  

example  :        12345            result will be  12345   

                         12345ABC     result will be 12345  

                         12345Z          result will be 12345  

Thanks for your help    


1 Reply

Re: Substring question

try with keepchar function

KeepChar('12345ABC', 1234567890)

KeepChar(yourfield, 1234567890)

Community Browser