# Basic Question : Can i convert unstructured Data into structured data for my analytical using logstash elasticsearch **URL:** \ **Category:** Logstash\ **Created:** [August 13, 2015, 8:23am UTC](https://discuss.elastic.co/t/basic-question-can-i-convert-unstructured-data-into-structured-data-for-my-analytical-using-logstash-elasticsearch/27306 "2015-08-13T08:23:51Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![rkhapre](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rkhapre/32/48333_2.png) [@rkhapre](https://discuss.elastic.co/u/rkhapre)\ **Post date:** [August 13, 2015, 8:23am UTC](https://discuss.elastic.co/t/basic-question-can-i-convert-unstructured-data-into-structured-data-for-my-analytical-using-logstash-elasticsearch/27306/1 "2015-08-13T08:23:51Z")
Hi All I have a very basic question, i have a column in my mysql database which hold records like this below Cashflow 250 rate 12% year 2 NPV -34 Like this i have data jumbled in whole column which is like a text Is there any logstash inplut plugin or elasticsearch river available to convert my data into structured format so that i can do mathematical calculation with it I need something like this after conversion Cashflow Rate Year NPV 250 12% 2 -34 ![](https://us1.discourse-cdn.com/elastic/original/2X/6/673f2889381d7a5143afd429b80ba0fc5375bb7f.png) Regards Ritesh ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [August 13, 2015, 8:29am UTC](https://discuss.elastic.co/t/basic-question-can-i-convert-unstructured-data-into-structured-data-for-my-analytical-using-logstash-elasticsearch/27306/2 "2015-08-13T08:29:23Z")
Yes, grok will do that for you as long as the data is ordered in that manner. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 5:32am UTC](https://discuss.elastic.co/t/basic-question-can-i-convert-unstructured-data-into-structured-data-for-my-analytical-using-logstash-elasticsearch/27306/3 "2017-07-06T05:32:05Z")