Logstash : convert string to array

Question

I have csv file that has types column with array of integers in format:

id,date,state,types,x,y
14518263,2021-01-01 20:20:00,2,"18,19,63,72",14.46154,50.07164

Could someone help me with converting types column into array via filter in pipeline?

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community
– Community Bot, Commented Dec 20, 2021 at 9:54

Paulo · Accepted Answer · 2021-12-12 21:08:50Z

1

So I feel you need two steps for this.

You will be using 2 mutation filter to do so.

filter {
    mutate {
        split => { "<your field name>" => "," }
    }
    mutate {
        convert => { "<your field name>" => "integer" }
    }
}

For reference there was a discussion going on here

answered Dec 12, 2021 at 21:08

Paulo

11k5 gold badges23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ashutosh kumar · Accepted Answer · 2022-12-19 13:11:46Z

0

You need to use two filter for this, First, you need to split it into string array based on the splitter or seperator then you need to convert it to desired data type here integer

mutate {
        split => { "field1" => "," }
        split => { "field2" => "," }
    }enter code here
    mutate {
        convert => { "field1" => "integer" }
        convert => { "field2" => "integer" }

answered Dec 19, 2022 at 13:11

Ashutosh kumar

1

Collectives™ on Stack Overflow

Logstash : convert string to array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related