Actually...
The data looks a bit more like this;
AA=value1,BB=value2,CC=value3,BB=value4,BB=value5
AA=value6,BB=value7,BB=value8
AA=value9,BB=value10,CC=value11
AA=value12,BB=value13,CC=value14,BB=value15,CC=value16
There are other fields (CC) that I am not interested in that are mixed up with the BB fields. There is always only one AA field per event. Each BB field may have an associated CC field.
I am only interested in the BB fields per AA
... View more
I have data that looks like this:
AA=value1,BB=value2,BB=value3,BB=value4
AA=value5,BB=value6,BB=value7
AA=value8,BB=value9
AA=value10,BB=value11,BB=value12
How do I extract all the BB fields for each AA field?
... View more
Update:
I have a server estate that is running both DEV and TEST instances of a number of applications. One source type has all the logs for the DEV instances and the other has all the logs for the TEST instances.
What I need is a report that lists all the DEV instances per host in one column and all the TEST instances per host in a separate column. Some hosts will only have DEV while other will only have TEST apps, but a handful will be running both DEV and TEST.
... View more