In our instrument logs, at various points we get a message like this:

DATACONNECTION - HWBytes:15,301,020 BPS:0 EvtFmBytes:15,001 HWEvents:15,001 EQE:True EQC:0 ListenRun:True ProcessRun:True DS:1020 SA:0 FES:True Name:FinalEventSeen

As shown in your video I would like to use SQL to pull out or even line graph the "EvtFmBytes:" and "HWEvents:" from these lines.

The automatic parser didn't do anything.

I tried the pattern parser but I am not sure it is dealing with the commas in the numbers correctly.   It seems to think it is a string and instead of finding similar columns it is just matching the one exact string.

We also have these lines:
SystemHealthTriggerSnapshot - Trig:AverageCpuLoad AverageCpuLoad - CPU:54% Speed:0GHz RAM:T-19.23GB/P-1.36GB/O-17.87GB Client:1%/424.93MB Server:48%/971.44MB Disk:B-235.53GB/P-235.53GB Net:A02919AAC2B0:R-8.03KB/S-1.51KB,005056C00001:R-0B/S-0B,005056C00008:R-0B/S-0B,8038FBA68B5A:R-0B/S-0B,8038FBA68B5E:R-0B/S-0B LoopAvg:206 LoopMax:2235 LoopMin:10

In a similar fashion I'd like to pull out CPU,  Data out of the "Server:" area which is CPU%/RAM used.

Some help to get started would be very much appreciated.