Okay I have two fields, first one is an error code, example:
ErrorCode_Field = 404
The second field is a sub code of that error code, example:
SubErrorCode_Field = 3
For some reason they entire code is split into two separate fields. I was able to combine the two into a single field to look like this:
FullErrorCode_Field=404.3
Using this code:
eval "FullErrorCode_Field"=ErrorCode_Field . "." . SubErrorCode_Field |
But I would like to put in some kind of "if" statement that says if the SubErrorCode_Field = 0
to not append it or the "." between the split fields to the FullErrorCode_Field. So for example:
if ErrorCode_Field = 404
and SubErrorCode_Field = 3
then FullErrorCode_Field=404.3
but
if ErrorCode_Field = 404
and SubErrorCode_Field = 0
then FullErrorCode_Field=404
Try like this
fixed typo
your current search | eval "FullErrorCode_Field"=ErrorCode_Field.if(tonumber(SubErrorCode_Field)=0,"",".".SubErrorCode_Field)
Try like this
fixed typo
your current search | eval "FullErrorCode_Field"=ErrorCode_Field.if(tonumber(SubErrorCode_Field)=0,"",".".SubErrorCode_Field)
You the man, that did the trick!
Thanks @snix for pointing the typo. Corrected the answer.