nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to remove part of a string that comes after last special character

Patricia2

Hi,

I'm looking to remove everything that comes after a special character in a string. The thing is that is not a specific number of letters after that character (it can vary) and also the special character appears many times before. For example from a string like this: "coffee_milk_sugar" I'd only want to remove "_sugar" and keep the rest. Is there a tool that I could use to only remove whatever comes after the LAST underscore??

Thank you!!

Common Use Cases

Transformation

Accepted answers

fmvizcaino

Hi @Patricia2 ,

Only another possibility, you could use the following function in your formula tool.

REGEX_Replace([Field1], '(.*)_([^_]+)', '$1')

Best,

Fernando Vizcaino

All comments

AbhilashR

Regex tool would be able to help you achieve this ask, or you could write a formula in the formula tool if that helps.

Attached is a sample implementation of the Regex tool.

sample.yxmd

Patricia2

Thank you, but according to that RegEx it would find any mention of the underscore and remove that. I what to be sure it only removes what comes after the last underscore in the string. Is that possible? Thanks

Quick Links

Popular Tags

Child Item

This months top contributors

atcodedog05 19598

Qiu 15960

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703