I agree I would use regular expressions to mimic the Oracle instr function, but I think it is also possible with a fairly ugly eval statement
... |eval fieldname=(if(mvcount(split(DSLAM_NAME,"_")>1,mvindex(split(DSLAM_NAME,"_"),0),mvindex(split(DSLAM_NAME,"-"),0))
Dave
... View more