How to Parse messages in csv format with only numbers with different column headings?

[cabishek188]

Hi all,

I want to be able to parse messages with just numbers. I have lot of .csv files with just numbers and different headings (some headings are the same across csv files)

For eg.

Col1, Col2, Col3
1,20,30
2,20,30

Col1, Col4, Col5
1,30,50
2,50,60

So these will be two messages. If I want to separate out the filter based on the Col names, how do I do that ?

Please help me.

[jkuang (Jimmy Kuang)]

I'm a bit confused on what you want.

So with your example:

Col1, Col2, Col3
1,20,30
2,20,30

Is a single document Col1 with 1 , 2 . Then Col2 20, 20 and Col3 30, 30 . Three documents.

or

Col1 , Col2, Col3 1 , 20 , 30 one document and Col1 , Col2, Col3 2, 20, 30 second document

or

One document

Col1, Col2, Col3
1,20,30
2,20,30

Second document

Col1, Col4, Col5
1,30,50
2,50,60

[cabishek188]

Hi,

It is:

One document

Col1, Col2, Col3
1,20,30
2,20,30

Second document

Col1, Col4, Col5
1,30,50
2,50,60

[jkuang (Jimmy Kuang)]

Awesome, my final question is

Col1, Col2, Col3
1,20,30
2,20,30

In the document above, Col1 , 2, 3 are arrays right? Col1 would contain 1,2. Col2 would be 20,20. Col3 would be 30 , 30 or is it 1, 20, 30 and 2 , 20 ,30.