# Extracting Matching Text

**URL:** <https://community.glideapps.com/t/extracting-matching-text/55267>\
**Category:** Ask for Help\
**Created:** [November 30, 2022, 10:02pm UTC](https://community.glideapps.com/t/extracting-matching-text/55267 "2022-11-30T22:02:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MisteryInc](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/misteryinc/32/75017_2.png) [@MisteryInc](https://community.glideapps.com/u/MisteryInc)\
**Post date:** [November 30, 2022, 10:02pm UTC](https://community.glideapps.com/t/extracting-matching-text/55267/1 "2022-11-30T22:02:32Z")

</div>

Has anyone used Glide’s Extracting Matching Text plugin? Is it good for getting specific text from address? I tried it but nothing happened.

For example I have a user enter 1600 Pennsylvania Avenue NW, Washington, DC 20500 as their address but only want the city and state(in this case, district).

For the plugin, I had placed address for the text and Pennsylvania, DC for the regular expression.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 1, 2022, 12:32am UTC](https://community.glideapps.com/t/extracting-matching-text/55267/2 "2022-12-01T00:32:28Z")

</div>

The column “extract text matching a regular expression”.

> **[JavaScript RegExp Reference](https://www.w3schools.com/jsref/jsref_obj_regexp.asp)**
>
> W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

If you type “address” in, that won’t work because that’s not a “regular expression”. I doubt you would get the address with that approach.

Since address can come in a huge range of forms, maybe there’s an API out there that let you:

- Use the original address as input
- Do a search and return the closest address object in their database, return a JSON object of all pieces of info related to that object.
- You can then query the right pieces out, e.g: city/state.