Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Kpim
Partner - Contributor
Partner - Contributor

Separate numbers between character

Hi

I have a dataset containing ref no : uf9m458700m7844132mn

                                                                         uf8m276932m789721mn

                                                                          uf7m908732m2681mn

 

How can I get the numbers between the m's at the end considering that the number is inconsistent? 

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Maybe like this:

subfield([field],'m',3)

View solution in original post

1 Reply
Vegar
MVP
MVP

Maybe like this:

subfield([field],'m',3)