Regex is not working - probably user error. Help appreciated

[AW2307]

Hi,

I would like to transform the following link such that any contents after the last "slash" character are removed:

• brain://xTYWKpB9VU2egO6JhqtDZg/ThisIsDummyText

So this would be the result:

• brain://xTYWKpB9VU2egO6JhqtDZg/

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.

[suliveevil]

@AW2307

The Regex expression should be correct

No, it's not, test it use any regex tool again:

regex101: build, test, and debug regex

[Lucien_Keller]

@AW2307

brain://xTYWKpB9VU2egO6JhqtDZg/ThisIsDummyText

You must escape backslash character

Try this

brain:\/\/.*\/(.*)

[suliveevil]

Why use wildcard characters instead of [a-zA-Z0-9]?

[AW2307]

@Lucien_Keller

You must escape backslash character
Try this
brain:\/\/.*\/(.*)

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.

[tiffle]

Just use this

[AW2307]

@suliveevil

Why use wildcard characters instead of [a-zA-Z0-9]?

My understanding is that it's necessary because these links sometimes contain underscores, i.e. they are not always alphanumeric.