Is there an easy way of removing (Mrs), (Mr), (Miss) from a character string?
Thanks
Hi
ChatGPT suggests you try “REGEXEXTRACT({Your Field}, “(?<=)\s).*”)”
This should extract the name after the title, assuming the title is in the format (Mr) Name.
Limitation: This works if the title is always enclosed in parentheses before the name.
Note: Knack uses the function extractRegex rather than REGEXEXTRACT.
Dean
Many thanks