trying to strip out a certain string from various length of string

Contains(Right([field], 3),'Iii' or 'Vii')

Accepted answers

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

Solution_M139076_Adj.yxmd

All comments

Bahouth12

Hi,

I am not sure but try to use REGEX_Replace function in the formula tool.

REGEX_Replace([Field], '[^Iii|^Vii]', '')

Thanks

AA007

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')

Bahouth12

Hi,

Share sample data will make it easier for the Community to assist you.

Thanks

AA007

App Developer I
App Developer II

Senior Marketing Officer and Controller
Account I
Account II
Account III
Accounting Services IV
Principal and title Ix

Bahouth12

Hi,

take a look at the attached workflow. let us know if that works fine with you.

Thanks

Solution_M139076.yxmd

AA007

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

Bahouth12

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

Solution_M139076_Adj.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703