QlikView App Dev

[Anonymous]

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

[m_woolf · Accepted solution]

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