Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pulling out part of the ID code

I need to be about to pull out part of an ID.  In the example list below I would need to pull out the numbers in the text string 11190 or 1995, what is the best why to do this?

Thanks,

Jen

SUB-2Y-11190-R
SUB-2Y-11995-R-DA
SUB-M-1995-R-AD
SUB-M-1995-R-BW
1 Solution

Accepted Solutions
m_woolf
Master II
Master II

subfield(ID,'-',3) as Whatever

View solution in original post

1 Reply
m_woolf
Master II
Master II

subfield(ID,'-',3) as Whatever