I have string fields and I want to extract the first two words (minus any punctuation or special symbols). Ideally, they would remove the white space and capitalize each word as well.So a field with “Midnight: A Tale” = “MidnightA”. ”What’s New in Bo...
Thank you, Pascal, this worked perfectly! For others trying it, I did include an additional field to capitalize the second word before concatenating them.IF({File second word}, UPPER(LEFT({File second word}, 1)) & (REGEX_EXTRACT({File second word}, "...
@Helen_Zeng, When using the record templates, is there a way to add links to existing records rather than create new linked records in the linked table?
