Extract results from field with ; seperated values

[paganom]

I want to do a timechart where I take inUsage & outUsage values. With a standard timechart I only get the first vaule 59.99% & 0.00% respectively. How do I get the results that follow each ";" and give them new names?

1313073123 src_host="ACH_INT_SWI_5" perfdata="SERVICEPERFDATA" name="ach-tw-www-interface" severity="OK" attempt="1" statetype="HARD" executiontime="0.414" latency="0.150" reason="Average IN: 12.00Mbps (59.99%), Average OUT: 469.33bps (0.00%) Total RX: 2.75TBytes, Total TX: 236.36MBytes" result="inUsage=59.99%;99;100 outUsage=0.00%;99;100 inBandwidth=11997373.47bps outBandwidth=469.33bps Bandwidth=20000000"

[acdevlin]

There's a few ways you could go about doing this.

I would personally suggest that you use the "Field Extractor" App to manually split up your data. This allows you to go into your raw data and define each individual field. I would personally suggest this method as it is pretty novice-friendly and requires no knowledge of regular expressions.

Does this help with your question?