Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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)