Csv with date column

Elastic Stack Logstash
1

hi all,

i have below blocks of csv data....date comes in first line followed by csv data ...i need to bring date with csv data as a column to process it with timestamp.

20210409 0030
Counter node-3 node-4 node-5 node-6 node-7 node-8 node-9 node-10 node-1 node-2
1.delta 0 0 0 0 0 0 0 0 0 0
2.delta 0 0 0 0 0 0 0 0 0 0
3.actual 0 0 0 1 0 0 0 1 1 0
4.actual 0 0 0 0 0 0 0 0 0 0
5.delta 0 0 0 0 0 0 0 0 0 0

20210409 0040
Counter node-3 node-4 node-5 node-6 node-7 node-8 node-9 node-10 node-1 node-2
1.delta 1 0 0 0 0 0 0 0 0 0
2.delta 0 0 0 0 0 0 0 0 0 0
3.actual 0 0 0 1 0 0 0 1 1 0
4.actual 0 0 0 0 0 0 0 0 0 0
5.delta 20 0 0 0 0 0 0 0 0 0

20210409 0045
Counter node-3 node-4 node-5 node-6 node-7 node-8 node-9 node-10 node-1 node-2
1.delta 30 0 0 0 90 0 0 0 0 0
2.delta 0 0 0 0 0 0 0 0 0 0
3.actual 0 0 0 1 0 0 0 1 1 0
4.actual 0 0 0 0 0 0 0 0 0 0
5.delta 0 0 0 0 0 0 0 0 0 0

any suggestions

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.