Fanning out "label" field into separate MySQL table fields

branchbunch branchbunch at gmail.com
Mon Jun 30 19:06:03 EDT 2014


When ralabel is set to use the GeoIP City file, the label field of a given
Argus record might contain numerous values like:
"scity=Orlando,FL,United States:dcity=Menlo Park,CA,United States"
Is there presently any mechanism to get rasqlinsert to fan that out into
multiple database fields like
FIELD VALUE
scity "Orlando"
sregion "FL"
scname "United States"
dcity "Menlo Park"
dregion "CA"
dcname "United States"

If that isn't a native feature, perhaps my next-best option would be follow
my mysqlinsert process with some further MySQL steps to use regex to parse
out the separate components of the "label" field into separate result
fields?

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20140630/a490fdcb/attachment.html>


More information about the argus mailing list