Solved! Go to Solution.
Hi there! So, probably a couple of ways to do this depending on your comfort level. You seem fine with expressions (which I'm not)...but it feels like we could probably do some string manipulation using "indexof" and/or "lastindexof" to find the positions of "?ID=" and whatever character follows the end of the URL, then use "substring" to single out those bits with a bit of math (to figure the length of the ID).
Another option would be a parsing tool like Parserr or Plumsail to do essentially the same thing, but with a friendlier interface.
Do either of those sound good?
-Ed-
If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Hi there! So, probably a couple of ways to do this depending on your comfort level. You seem fine with expressions (which I'm not)...but it feels like we could probably do some string manipulation using "indexof" and/or "lastindexof" to find the positions of "?ID=" and whatever character follows the end of the URL, then use "substring" to single out those bits with a bit of math (to figure the length of the ID).
Another option would be a parsing tool like Parserr or Plumsail to do essentially the same thing, but with a friendlier interface.
Do either of those sound good?
-Ed-
If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
User | Count |
---|---|
76 | |
59 | |
48 | |
30 | |
20 |
User | Count |
---|---|
28 | |
27 | |
26 | |
21 | |
20 |