Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

extract a text from a string

Hi togehter,

i have a set of IDs and would like to extract the text:

 

ID:

ABCD123455677 --> should be ABCD

DEL18383939393930303 --> Should be DEL

The lenght of the ID and containing variouses. 

Labels (1)
1 Solution

Accepted Solutions
y_grynechko
New Contributor III

Re: extract a text from a string

Hey,

one of a few options: 

Przechwytywanie.PNG

I

2 Replies
y_grynechko
New Contributor III

Re: extract a text from a string

Hey,

one of a few options: 

Przechwytywanie.PNG

I

Partner
Partner

Re: extract a text from a string

Thxs a lot. This solved my problem perfectly 🙂