# Parse a string to get a number

**URL:** <https://discuss.elastic.co/t/parse-a-string-to-get-a-number/187500>\
**Category:** Kibana\
**Created:** [June 26, 2019, 7:23am UTC](https://discuss.elastic.co/t/parse-a-string-to-get-a-number/187500 "2019-06-26T07:23:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tosser](https://avatars.discourse-cdn.com/v4/letter/t/e79b87/32.png) [@Tosser](https://discuss.elastic.co/u/Tosser)\
**Post date:** [June 26, 2019, 7:23am UTC](https://discuss.elastic.co/t/parse-a-string-to-get-a-number/187500/1 "2019-06-26T07:23:39Z")

</div>

Some guy who already does not work here installed ELK and Kibana and everything was fine until we installed a new server. We need to parse a string to take a number out of it and put it into visualisation in Kibana. I'm very new to Kibana and got no idea where to start.  
The version is 6.6.0  
ELK receives a json and parses it into multiple fields.  
The field I'm interested in is named "syslog\_message" and looks like this:  
"OrderMaker: Order #152491 took 0.45s, 3231 codes/s"  
I need to get this number "3231" out of string, combine it with @timestamp from another field (same json) and put it into visualisation.  
Also there're different messages in this field that do not look similar to this one. As far as I can tell I need to somehow search for "codes/s" and take the symbols that come before it, then convert them into a number.

Could you please tell me where to begin? Should I read something related directly to this issue?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 24, 2019, 7:23am UTC](https://discuss.elastic.co/t/parse-a-string-to-get-a-number/187500/2 "2019-07-24T07:23:50Z")

</div>

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