How to search for specific string with Alteryx

[JinOnn]

How do I extract the numbers highlighted in red?

The numbers are the same except for the last 6 digits.

How do I extract that specific number when it appears differently at each row?

[Emil_Kos · Accepted solution]

Hi @JinOnn,

Can you try this workflow?

It should work for you. 

[JinOnn]

Thank you so much!