Hello everyone! I have the following problem: I need to parse the Next route. Don't know how describe the task in words so let me explain it on the example. [number-number...] means that there can be any number delimited by "-". The whole routeCurrent pointPassed routeNext route[number-number...]-388-[number-number...]-388-[number-number...]-388-201388[number-number...]-388-[number-number...]-388388-[number-number...]-388-201[number-number...]-388-[number-number...]-388-[number-number...]-388-201388[number-number...]-388388-[number-number...]-388-201 So if current point appears 2 times in passed route than I need to delete data after second appearance of the current point. If current point appears 1 time in passed route than I need to delete data after first appearance of the current point. If current point appears 3 times in passed route than I need to delete data after third appearance of the current point. Etc

Parse data

Hello everyone!

I have the following problem:

I need to parse the Next route. Don't know how describe the task in words so let me explain it on the example.

[number-number...] means that there can be any number delimited by "-".

The whole route	Current point	Passed route	Next route
[number-number...]-388-[number-number...]-388-[number-number...]-388-201	388	[number-number...]-388-[number-number...]-388	388-[number-number...]-388-201
[number-number...]-388-[number-number...]-388-[number-number...]-388-201	388	[number-number...]-388	388-[number-number...]-388-201

So if current point appears 2 times in passed route than I need to delete data after second appearance of the current point. If current point appears 1 time in passed route than I need to delete data after first appearance of the current point. If current point appears 3 times in passed route than I need to delete data after third appearance of the current point. Etc

Parse

Help

Accepted answers

neilgallen

Apologies. Attached is a revised version. Once again a bit complicated but should work. The simpler version posted earlier works only in situations where the locations are never substrings of other locations.

Example - Route Parse.yxmd

All comments

neilgallen

@Nastya This is a bit complicated and there may be (and probably is) a simpler route to get there, but this should accomplish what you're looking for. In situations like this splitting your data into rows has been the best route in my experience.

route parse image.PNG

Example - Route Parse.yxmd

Nastya

thank you very much!!!

Don't you mind if I won't push "Accept as solution" button? In hope that easier solution can be found

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703