I want to remove everything before the word 'of'' in the below table
Output:
One way to do this (I've attached the workflow):
Before:
After:
Hi @Sshasnk
You can do this using this regex expression
of\s(.*)
@Felipe_Ribeir0 @BS_THE_ANALYST Can I do it using formula tool ?
Yes, use the formula called REGEX_Replace([value], ".*of\s*(.*)", "$1")... see picture below
@Sshasnk
Yes, with this formula
REGEX_Replace([value], '(.*\sof\s)', '')
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!
