Fanning out "label" field into separate MySQL table fields

[Carter Bullard]

Hey Kevin,
You’re way ahead of the story at this point.
Let me get 3.0.8 out and we’ll talk about new features/functions.

So this belongs in the general metadata support feature set.

Currently the clients will ensure that, in your example, “Orlando"
will occur only once in your scity label, regardless of how many
times you label, aggregate, whatever.

If you start to describe what you think should be in your
feature, we can start to generalize how metadata support will go.

Carter

On Jun 30, 2014, at 7:06 PM, branchbunch <branchbunch at gmail.com> wrote:

> 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 --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 455 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20140630/296483fc/attachment.sig>