From Right to a specific character

ChrisB_dup_72

Hi Everyone,

I'm having trouble figuring this out.

I have a data in this format. Most of the code is delimited by a period but the last part by a colon.

NW.SEAS.B154.1.LRC01:AI 1

NW.SEAS.B154.FHC01:AI_7

NW.AL3.256.LR:CTL TEMP

I need to take the portion that is to the right from the last period. For example:

From “NW.SEAS.B154.1.LRC01:AI 1”, I need “LRC01:AI 1”

From “NW.SEAS.B154.FHC01:AI_7”, I need “FHC01:AI_7”

From “NW.AL3.256.LR:CTL TEMP”, I need “LR:CTL TEMP”

Does anyone know of a tool or formula that will take the characters to the right of a specific delimiter?

Thank you,

Chris

Parse

Accepted answers

CharlieS

Use this expression in a Formula tool where [Input] is the field containing the code values you provided as example.

Right([Input],FindString(ReverseString([Input]),"."))

This expression works based on the fact that you need the Right side of the string after the last period character. While we don't have a string function for the last character, we do have functions to reverse the characters of a string and then to find the first character.