I need to get the first letter in a word in my Airtable Table. I used Regex ( copied from Airtable Community Topic ) with a formula column but I’m getting the first two letters. But I need only the first letter.
Here’s the Regex that I copied from Airtable Forum:
REGEX_REPLACE(Name, "\\B\\w+\\W*", "")
Not sure how to do it. I’m new with Regex
Appreciate any help!
Are you doing this in Airtable, or in Glide?
Thanks Darren for that fast reply!
Thanks again for the reply!
oh, in that case I can’t help you - sorry
No problem Darren! Thanks for your reply!
I like to ask if I do this in Glide with the Extract Matching Column what would be the Regex Code?
I know there is a Plugin that already created for this user case but I like to use every features in Glide
It depends on your definition of a letter. Most likely what you want is
Yeah! After some research finally I found how to do this on Airtable!
This is the Regex Code :
And the result :
And also thanks Darren because your code also works on Glide Too!
Thanks again Darren for your fast reply and help! Really Appreciated!
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.