Validity Customer Community

@Roger_Coville , Thanks to my colleague @AnthonyValidity who came up with an alternative which is simpler and may work better.   You can try both and see what works best. AllTextAfterChar(RegExReplace(${FirstName}, "and ", "And "), "And ")

@Roger_Coville , I think I have a solution.  Try this as your modify function:  Should find both 'and' & 'And' and return all the letters to the right of the 'and' IFERROR(RIGHT(${FirstName},LEN(${FirstName})-FIND(" and",${FirstName},1)-3),IFERROR(RI...

thanks Roger, fun topic for me to look into tomorrow and definitely one for the wider community. I'll have a play tomorrow am and let you know what I find.