# How to extract data from this pattern, with grok filter its not working
**URL:** https://discuss.elastic.co/t/how-to-extract-data-from-this-pattern-with-grok-filter-its-not-working/148486
**Category:** Logstash
**Created:** [September 13, 2018, 5:17pm UTC](https://discuss.elastic.co/t/how-to-extract-data-from-this-pattern-with-grok-filter-its-not-working/148486 "2018-09-13T17:17:11Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@rkhapre](https://discuss.elastic.co/u/rkhapre)
#### Post date: [September 13, 2018, 5:17pm UTC](https://discuss.elastic.co/t/how-to-extract-data-from-this-pattern-with-grok-filter-its-not-working/148486/1 "2018-09-13T17:17:12Z")
How to extract data from this pattern, with grok filter its not working
below data is available in log file
> logEvent": {
> "message": "JDBC - Exception. Not retrying. event: "{"LastModifiedDate":"2018-09-12T18:19:15.000Z","Ownership":"Public","Website":"[http://www.uos.com](http://www.uos.com)","NumberOfEmployees":24000"}
I need to extract column/event name as "NumberOfEmployees"
NumberOfEmployees : 24000
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [September 17, 2018, 4:50pm UTC](https://discuss.elastic.co/t/how-to-extract-data-from-this-pattern-with-grok-filter-its-not-working/148486/2 "2018-09-17T16:50:46Z")
Since you didn't post the log snippet as preformatted text it has been mangled so it's not clear exactly what it looks like. But it seems to be JSON, in which case you should use a json filter to parse it.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 15, 2018, 4:50pm UTC](https://discuss.elastic.co/t/how-to-extract-data-from-this-pattern-with-grok-filter-its-not-working/148486/3 "2018-10-15T16:50:48Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.