Get the First Letter in a Word

[Dilon_Perera]

Hi Everyone,

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!

Thank you

[Darren_Murphy]

Are you doing this in Airtable, or in Glide?

[Dilon_Perera]

Thanks Darren for that fast reply!

In Airtable.

Thanks again for the reply!

[Darren_Murphy]

oh, in that case I can’t help you - sorry

[Dilon_Perera]

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

[Darren_Murphy]

It depends on your definition of a letter. Most likely what you want is ^(\w)

[Dilon_Perera]

Yeah! After some research finally I found how to do this on Airtable!

This is the Regex Code :

REGEX_EXTRACT(Name, "\\b[a-zA-Z]")

And the result :

And also thanks Darren because your code also works on Glide Too!

Code :

^(\w)

Result :

Thanks again Darren for your fast reply and help! Really Appreciated!

Glide Rock

Thank you