Contains(Right([field], 3),'Iii' or 'Vii')
Solved! Go to Solution.
Hi,
I am not sure but try to use REGEX_Replace function in the formula tool.
REGEX_Replace([Field], '[^Iii|^Vii]', '')
Thanks
the passed checking variable is not limited to just two conditions
[length of last word] = 3 && Contains(Right([field], 3),'Iii' or 'Vii') ||
[length of last word] = 2 && Contains(Right([field], 2), 'Ii' or 'Iv' or 'Vi' or 'Ix' )||
[length of last word] = 1 && Contains(Right([field], 1),'I' or 'V' or 'X')
Hi,
Share sample data will make it easier for the Community to assist you.
Thanks
App Developer I
App Developer II
Senior Marketing Officer and Controller
Account I
Account II
Account III
Accounting Services IV
Principal and title Ix
my aim is to strip the final denominations and group them together i have tried multiple regexes but failed where if I have some thing like vice principal and accounting v i would end up with ice principal and accounting v
Hi @AA007,
I changed the solution logic by adding te Find Replace Tool. This will let you list any string that you want to strip out from string. Take a look at the attached solution.
Thanks