I would like to transform the following link such that any contents after the last "slash" character are removed:
So this would be the result:
However, after running the following steps in the macro with the original text in the clipboard, the clipboard appears to remain unchanged and the original link gets pasted.
The Regex expression should be correct, but I must be doing something wrong inadvertently. Would highly appreciate your input.
No, it's not, test it use any regex tool again:
You must escape backslash character
Why use wildcard characters instead of
Duh! I do know that certain characters need to be escaped but completely forgot in this case.
Also, for some reason the application I use to check RegEx expressions didn't flag this. No excuses though
Thanks, problem solved.
My understanding is that it's necessary because these links sometimes contain underscores, i.e. they are not always alphanumeric.