Formula to Trim Cell From Right by Special Character

SergeantPup

Hi,

I found this elsewhere on the forum and it works 100% as expected but as soon as I change out the special character to what I need it to be, I get Unparsable errors.


The formula that works is:

=RIGHT([Area Path]@row, FIND(">", [Area Path]@row, 1) - 1)

with the desired outcome:

But as soon as I change it to the character I actually need (not just following an example) it barfs:

=RIGHT([Area Path]@row, FIND("\", [Area Path]@row, 1) - 1)

So I know the function works, it's just not working for my character and I don't know why. Can somebody help me get this working to strip away everything up to and including the "\" please?

Paul Newcome

The FIND function outputs a number based on how far from the LEFT of a text string a character is found. The FIND function in the most recent screenshot is outputting 12. Dropping this into the RIGHT function means you are saying to pull the 12 rightmost characters.

Try subtracting the FIND output from a LEN function.

LEN([Area Path]@row) - FIND(…………)

Paul Newcome

I can't remember exactly what it is called, but the back-slash is a special kind of special character. I think it is called an "escape character" maybe.

Either way, try searching for a double back-slash instead.

FIND("\\", [Area Path]@row, 1)

SergeantPup

thanks. that stopped it from barfing but gave unexpected results:

=RIGHT([Area Path]@row, FIND("\\", [Area Path]@row, 1) - 1)

The goal would be for the team name to just say World

Paul Newcome

The FIND function outputs a number based on how far from the LEFT of a text string a character is found. The FIND function in the most recent screenshot is outputting 12. Dropping this into the RIGHT function means you are saying to pull the 12 rightmost characters.

Try subtracting the FIND output from a LEN function.

LEN([Area Path]@row) - FIND(…………)

SergeantPup

That worked, thanks

=RIGHT([Area Path]@row, LEN([Area Path]@row) - FIND("\\", [Area Path]@row, 1) - 0)

Paul Newcome

Happy to help. 👍️