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"
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?