Return number of characters after a particualr character

[cstafford]

I am curious what is the best to return a certain number of characters in a string. I usually use Left or Right, but in this case the RIGHT function will not work properly. Is there way to return all characters from the RIGHT up to a certain character, in this case the underscore.

Ex.

FRT_CNN_3

FRT_CNN_3R

I want to return the 3 and 3R, if I do right, 2, I get the underscore in the first example and I do not want that. However, is it possible to return all characters from the right after the underscore?

[Thableaus · Accepted solution]

Hi @cstafford 

Using REGEX you can easily accomplish that.

REGEX_Replace([Field], ".*_(.*)", "$1")

Cheers,

[Thableaus · Accepted solution]

@cstafford 

Another way of doing it:

Right([Field1], FindString(ReverseString([Field1]), "_"))

Using the Right function + other string functions.

Let me know if you have any questions.

Cheers,