How do I parse this?

[codytom]

5852340912828WY2

172139729128284W7

I just wanted the 912828+

Any ideas on how to get rid of anything once 912 starts?

[marcusblackhill]

Hey @codytom !

You need to get everything after the "912"? You can use the regex  "912.*" for that.

If you need to get every number after 912 and before the letters, can use "912[0-9]*"

Hope that helps, if not, can explain a little bit more your issue?

[codytom]

Thanks!

Using the RegEx tool right?

[codytom]

hmm, for some reason its not working for me?

Its like Regex isn't even picking up the pattern

is the expression "912.*" correct? 

[marcusblackhill]

Yes @codytom , use regex tool with tokenize as output method and you will get what you want! 😉

If that helped, please mark as solution to be easier to others find that answer.

[marcusblackhill · Accepted solution]

Configure Regex tool like this just for numbers

Or like this for everything after the 912.

[codytom]

It worked!

Thank you so much appreciate it!

[marcusblackhill]

Nice @codytom ! Happy to help, always count with us of the community 😁