# String extraction Regex : influxDB

**URL:** <https://community.influxdata.com/t/string-extraction-regex-influxdb/3143>\
**Category:** Store\
**Tags:** influxdb, influxql\
**Created:** [November 20, 2017, 2:39am UTC](https://community.influxdata.com/t/string-extraction-regex-influxdb/3143 "2017-11-20T02:39:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sniper](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@sniper](https://community.influxdata.com/u/sniper)\
**Post date:** [November 20, 2017, 2:39am UTC](https://community.influxdata.com/t/string-extraction-regex-influxdb/3143/1 "2017-11-20T02:39:15Z")

</div>

Team, Can we perform regular expressions on Strings and store them in influxDB?  
for ex: Have data in measurements where strings contain

Downlink Access switch **sw-s1a** ; switch\_mon:ignore\_mac

Is it possible to extract only the sub-string sw-s1a

Kindly let me know. Thanks

---

<div class="post-metadata">

**Author:** ![sniper](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@sniper](https://community.influxdata.com/u/sniper)\
**Post date:** [November 20, 2017, 3:56am UTC](https://community.influxdata.com/t/string-extraction-regex-influxdb/3143/2 "2017-11-20T03:56:24Z")

</div>

Documentation does mention it supports GoLang Regex. Only question is how can we get custom groups i.e. group(1) / group(2) etc. equivalent in an SQL like expression? Thanks

---

<div class="post-metadata">

**Author:** ![Ashish\_Sikarwar](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/ashish_sikarwar/32/2074_2.png) [@Ashish\_Sikarwar](https://community.influxdata.com/u/Ashish_Sikarwar)\
**Post date:** [July 31, 2019, 12:11pm UTC](https://community.influxdata.com/t/string-extraction-regex-influxdb/3143/3 "2019-07-31T12:11:40Z")

</div>

Did you find a resolution on this topic anywhere else?