Search Field Extraction help

[lisaac]

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.

[gkanapathy]

Seems pretty likely that:

[mysourcetype]
EXTRACT-xml = \<COL\s+ID=\'(?<_KEY_1>[^\']+)\'\>(?<_VAL_1>[^\>]+)\<\/COL\>

should do it.