Hi, Splunkers, | where ENT_CallType=if($t_VQ$ =="*","*",ltrim($t_VQ$,"VQ_")) t_VQ is a dropdown token, value is either ALL/* or VQ_abc_efg (string starting with VQ_) what my code expected is...
See more...
Hi, Splunkers, | where ENT_CallType=if($t_VQ$ =="*","*",ltrim($t_VQ$,"VQ_")) t_VQ is a dropdown token, value is either ALL/* or VQ_abc_efg (string starting with VQ_) what my code expected is when t_VQ = *, then |where ENT_CallType=* when t_VQ = VQ_abc_efg, then |where ENT_CallType=abc_efg but when I selected ALL/*, has the following error Error in ‘where’ command: The expression is malformed. An unexpected character is reached at ‘* == “*”,”*”, ltrim(*,”VQ_”) when VQ_abc_efg is selected, doesn't work either. thx in advance Kevin