Trim right hand portion of text

Hi,

I've looked at the different trim variations, but I need one that will cut off a certain amount of characters from the right hand of a field.

My values look like Blue4509, Blue2034, Yellow2345, Orange2341

I'd like to cut off the last 4 values so that I get Blue, Yellow, Orange

Thanks!

Expression

Accepted answers

RodL

You could use Left(Data, (Length(Data) - 4))

tom_montpool

Using Left([Data],Length([Data])-4) will work well if all your numbers are four digits.

A more forgiving approach would be to use a regular expression either in the RegEx tool or using Regex_Replace in the Formula tool.

In the Formula tool, your expression could be RegexReplace([Data],"(\l+)\d*","$1")

All comments

RodL

You could use Left(Data, (Length(Data) - 4))

tom_montpool

Using Left([Data],Length([Data])-4) will work well if all your numbers are four digits.

A more forgiving approach would be to use a regular expression either in the RegEx tool or using Regex_Replace in the Formula tool.

In the Formula tool, your expression could be RegexReplace([Data],"(\l+)\d*","$1")

simpleminded

Hi Tom_montpool,

I am new to Regular Expressions. Can you explain what does the expression do? The one that you have written. Thanks.

benjaminmartin16

hello, thank you for this reply! I was wondering if someone could explain what it is doing in simple terms for me so that I can learn how to adapt it in the future instead of just copying your work. thanks in advance!!!

EN6924

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703