Basic Question : Can i convert unstructured Data into structured data for my analytical using logstash elasticsearch

(Ritesh) #1

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


(Mark Walkom) #2

Yes, grok will do that for you as long as the data is ordered in that manner.

(system) #3