Remove everything after the last "/" but keep this character

joannasokolowska

Dear Colleagues,

Please advise the best Formula or Regex expression for the case below.

I would like to remove everything which is after the last "/" but keep this character.

Input data:

John/Kovalsky/Green234&*@oj

Anna/2012305abd

Desire result:

John/Kovalsky/

Anna/

Thank you

Asia

Regex

Accepted answers

atcodedog05

Hi @joannasokolowska

The formula would be something like below

REGEX_Replace([Input], "(.*/)(.*)", "$1")

Regex always tries to fit in most of the characters in the initial pattern while maintaining the overall pattern. Hence all the chars before last / will be captured in first brackets(.*/). And we just need to replace the whole string with the first captured group.

Workflow:

Hope this helps : )

before char.yxmd

binu_acs

@joannasokolowska using regex tool

All comments

atcodedog05

Hi @joannasokolowska

The formula would be something like below

REGEX_Replace([Input], "(.*/)(.*)", "$1")

Workflow:

Hope this helps : )

before char.yxmd

binu_acs

@joannasokolowska using regex tool

joannasokolowska

Thank you both for a quick help!

Asia

atcodedog05

Happy to help : ) @joannasokolowska

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703