Remove everything before a word in the formula tool

[Sshasnk]

I want to remove everything before the word 'of'' in the below table

value

Making of debt

taking of sell

cooking of the meal

Output:

value

debt

sell

the meal

[BS_THE_ANALYST]

One way to do this (I've attached the workflow):

Before:

After:

[Felipe_Ribeir0]

Hi @Sshasnk 

You can do this using this regex expression

of\s(.*)

[Sshasnk]

@Felipe_Ribeir0 @BS_THE_ANALYST  Can I do it using formula tool ?

[BS_THE_ANALYST]

Yes, use the formula called REGEX_Replace([value], ".*of\s*(.*)", "$1")... see picture below

[Felipe_Ribeir0]

@Sshasnk 

Yes, with this formula

REGEX_Replace([value], '(.*\sof\s)', '')

[RobertOdera]

Hi, @Sshasnk 

Please see the below.

TRIM(Replace(Substring([Desc],FindString([Desc], "of")),"of",''))

Please mark it as an acceptable solution if it works for you.

Cheers!