I need to get data after the last number in passed route including this number. For example: The whole routePassed routeNext route388-351-302-351-406-255388-351-302-351351-406-255344-382-254-476344-382382-254-476251-202-4975-202-656-202-3221251-202-4975-202-656-202202-3221 But the problem is that passed route doesn't always match the whole route. For example.: 388-351-302-456-351-406-255388-351-302-351351-406-255 So, it's needed to orientate on the number of times the last point was in the string Thanks a lot for any help!

Parsing data

I need to get data after the last number in passed route including this number. For example:

But the problem is that passed route doesn't always match the whole route. For example.:

388-351-302-456-351-406-255

388-351-302-351

351-406-255

So, it's needed to orientate on the number of times the last point was in the string

Thanks a lot for any help!

Workflow

Parse

Okay.

Here is a new solver. Clearly a bit more complex but it works for your given scenario.

Ben

To confirm at the start you have your first two columns and you want to get the 'next route' column?

Yes