Parsing data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to get data after the last number in passed route including this number. For example:
The whole route | Passed route | Next route |
388-351-302-351-406-255 | 388-351-302-351 | 351-406-255 |
344-382-254-476 | 344-382 | 382-254-476 |
251-202-4975-202-656-202-3221 | 251-202-4975-202-656-202 | 202-3221 |
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
To confirm at the start you have your first two columns and you want to get the 'next route' column?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In the second part of my message I told about this problem:
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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry that one was awfully close to the first one and I mistook them as identical which they are not.
My question is in this case. How many pieces can be missing?
For example...
388-351-302-456-351-406-255 | 388-351-302-300-406 | What is this? |
and
388-351-302-456-351-406-255 | 388-232-302-342-351 | What is this? |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Any number of pieces, there is not fixed one. That's the problem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator