rename data

[haziqwebs]

I want to rename CPU001 to CPU1, CPU_ALL to CPUALL, is it possible?

[somesoni2]

If you're looking to rename/update field values with CPU* format (not only CPU001 but CPU002 as well, give this try

Your current search | eval Jenis=replace(Jenis,"(00|_)","")

[woodcock]

Like this:

... | replace "CPU001" WITH "CPU1" "CPU_ALL" WITH "CPUALL" IN Jenis

[jmallorquin]

Hi,

Yes, just put this at the end:

| eval Jenis = case (Jenis="CPU001","CPU1",Jenis="CPU_ALL","CPUALL")

Hope i help you