I have been trying to import my mySQL database into Elasticsearch through Logstash but I am stuck (for two days now) to separate three columns into separate fields. I want to split these into different fields so it displays as: "dr_behaviour_Patient Healer": "5", "dr_behaviour_Couldn’t Care Les…

I thought the " include_brackets => false" will remove it but I think you can add these symbols in the trim options : filter { kv { source => "dr_behaviour_rate" prefix => "dr_behaviour_" field_split => "," include_brackets => false value-split => "\[" trim_key => "\s\[\…

Trying to separate key-value pairs in nested array (help with RUBY)

Elastic Stack Logstash

Harshet_Jain (jainh) October 11, 2018, 3:44pm 3

Thank you. This solved it. One issue remains. I am getting the data as:

"dr_behaviour_Patient Healer": "1]",

How do I remove the last "]"?

Topic		Replies	Views
Problem converting multi-delimited kv string Logstash	7	307	May 3, 2020
KV filter is unable to handle = within a key value Logstash	6	1326	November 14, 2017
KV Filtering data between square brackets Logstash	7	1879	May 1, 2018
How to Split the one field into multiple fields using kv plugins Logstash	5	2692	April 11, 2019
Split string into array and then into key value pairs Logstash	3	1973	March 18, 2021

Trying to separate key-value pairs in nested array (help with RUBY)

Related topics