# Extracting only letters from text using RegEx

**URL:** <https://community.glideapps.com/t/extracting-only-letters-from-text-using-regex/59607>\
**Category:** Ask for Help\
**Created:** [March 23, 2023, 10:08pm UTC](https://community.glideapps.com/t/extracting-only-letters-from-text-using-regex/59607 "2023-03-23T22:08:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![KPT](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@KPT](https://community.glideapps.com/u/KPT)\
**Post date:** [March 23, 2023, 10:08pm UTC](https://community.glideapps.com/t/extracting-only-letters-from-text-using-regex/59607/1 "2023-03-23T22:08:04Z")

</div>

I’ve been trying to setup an “Extracting Matching Text” column, but I just can’t get it to work.  
I’m trying to extract just letters from an input field using this regular expression [A-Za-z]+ however it just does not work, does anyone know what I’m missing?

 ![Screenshot 2023-03-23 at 22.04.20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d09011836c8ec2cde8f0dca94a5f665ad5b56749.png)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 23, 2023, 10:52pm UTC](https://community.glideapps.com/t/extracting-only-letters-from-text-using-regex/59607/2 "2023-03-23T22:52:00Z")

</div>

Use the Java column, and paste this code:

`return p1.replace(/[^\p{L}]/gu, '')`

 ![Screen Shot 2023-03-23 at 6.50.51 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2bc072d993d80c5f9f33839aef34eeb8b473dc95.jpeg)

---

<div class="post-metadata">

**Author:** ![KPT](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@KPT](https://community.glideapps.com/u/KPT)\
**Post date:** [March 24, 2023, 6:31am UTC](https://community.glideapps.com/t/extracting-only-letters-from-text-using-regex/59607/3 "2023-03-24T06:31:04Z")

</div>

Thank you @Uzo 🙏 - works like a charm

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 24, 2023, 6:31am UTC](https://community.glideapps.com/t/extracting-only-letters-from-text-using-regex/59607/4 "2023-03-24T06:31:47Z")

</div>

You’re welcome… Java is the most powerful tool in glide.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 25, 2023, 6:31am UTC](https://community.glideapps.com/t/extracting-only-letters-from-text-using-regex/59607/5 "2023-03-25T06:31:55Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.