Hi sushma6,
something like this should work:
... | spath | eval myDevision=filesize/transtime | table myDevision
This is because when spath is called with no path argument, spath runs in "auto-extract" mode, where it finds and extracts all the fields from the first 5000 characters in the input field which defaults to _raw if another input source isn't specified.
If spath really does not work, you could try some regex to get the fields like this:
... | rex "\<filesize\>\s(?<myFilesize>\d+)\s.+\<transtime\>\s(?<myTranstime>\d+)\s" | eval myDevision=myFilesize/myTranstime | table myDevision
btw, are you aware that there are some spaces around the numeric values or is this just a copy/paste error?
In your case you can remove spaces from values like this:
... | spath | eval myFilesize=ltrim(filesize) | eval myTranstime=ltrim(transtime) | eval myDevision=myFilesize/myTranstime | table myDevision
hope this helps ...
cheers, MuS
... View more