Extract the data after the word "CLASS"

[nmotiani]

For example

Field 1

ABCD ABCDEF CLASS A-I

ABCD ABCDEF CLASS B-II

ABCD ABCDEF CLASS C-III

Desired Output:

A-I

B-II

C-III

[DataNath]

Hey @nmotiani, there's a few ways to do this. I always like playing around with standard string functions if we can get away with it so here's one method if you use this expression in a Formula tool:

Right([Field 1],
FindString(
ReverseString([Field 1]), 'SSALC')-1)

Can also just use the RegEx tool in parse mode with the following:

CLASS\s(.*)

[binuacs]

@nmotiani using regex_Replace function

[aatalai]

@nmotiani it can also be done with the regex tool