The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I’d just REGEX REPLACE for this to match everything but the first letter and replace it with “”. As follows:
REGEX_REPLACE({Field},"[a-z]+[a-z\s]","")
This matches whole words, minus the first character
REGEX_REPLACE({Field},’(\B\w)*’,’’)
But yes, no...