# Substring record basing on numerical index

**URL:** https://discuss.elastic.co/t/substring-record-basing-on-numerical-index/209286
**Category:** Logstash
**Tags:** elastic-stack-sql
**Created:** [November 25, 2019, 10:51am UTC](https://discuss.elastic.co/t/substring-record-basing-on-numerical-index/209286 "2019-11-25T10:51:20Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [November 25, 2019, 2:19pm UTC](https://discuss.elastic.co/t/substring-record-basing-on-numerical-index/209286/2 "2019-11-25T14:19:13Z")

</div>

You can use mutate+gsub to capture fixed length substrings. See [this](https://discuss.elastic.co/t/problem-with-split-and-add-field-in-mutate-filter/208883/4).

---

_[View the full topic](https://discuss.elastic.co/t/substring-record-basing-on-numerical-index/209286)._