I have an _raw event with data that I would like to break out into key value pairs. I was wondering if anyone had any suggestions on how to best accomplish this task at search time based on the following data set:
<COL ID='CARDS_ALIAS_ID'>1111111</COL><COL ID='PROFILE_ALIAS_ID'>44444444</COL><COL ID='TXT_MSG_TYP_2'>5555</COL>
I would like to have the fields CARDS_ALIAS_ID, PROFILE_ALIAS_ID, and TXT_MSG_TYP_2.
Seems pretty likely that:
[mysourcetype]
EXTRACT-xml = \<COL\s+ID=\'(?<_KEY_1>[^\']+)\'\>(?<_VAL_1>[^\>]+)\<\/COL\>
should do it.