Trim anything left after the latest dash character

Hello,

Could you please advise how to trim anything left after the latest dash " - " . There are several " - " in the string, so I am focused only whatever comes after the latest " - ". It will great if you could also explain the expression.

Text:

2019 KWK Competitive scoping - Grand *Total - 09 Tut A'more

The desired output: 09 Tut A'more

Thanks

Preparation

Accepted answers

danilang

Hi @adombayeva

You can use the following

REGEX_Replace([Field1], ".*-(.*)", "$1")

.*- This matches any characters up to and including a dash. Because Regex is greedy by default, any hyphens that appear before the last one are caught by the ".*", so the expression matches everything up to the last hyphen

(.*) The ".*" will match any number of characters. Since it's surrounded by brackets, its seen as a capturing group. Any characters that match this pattern are captured and can be used later. Since this is the first group you use "$1" to refer to it. This is used in the replace clause to replace the entire contents of Field1 with the characters that follow the last hyphen

Dan

TrimAfterDash.yxmd

All comments

danilang

Hi @adombayeva

You can use the following

REGEX_Replace([Field1], ".*-(.*)", "$1")

Dan

TrimAfterDash.yxmd

adombayeva

Hi @danilang,

Thank you very much for support! The expression helped me to solve the issue and your explanation became an invaluable knowledge for me to practice further!

Cheers 🙂

Anthony_A2

Hi @danilang

How would you reverse this if you wanted to trim everything after the last hyphen?

I have an instance where I have a column of identifiers with variable amount of hyphens in each record. I always want to grab everything before the last hyphen.

Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703