How to convert the alphnumeric values to numeric values, each time the length of the values changes.
Can someone suggest?
ClusterCPUUsed=31684
ClusterCPUHALimit=383880
HARamGBLimit=589
ClusterMemUsedGB=201
I'm not quite sure what you would like to achieve.
Are these different fields from a single event or are they separate events? What would you like to have as output?
Hi @PickleRick - Those values are from same events, Looking to show only the numbers
The numbers whichever coming after equal to symbol has to show for the field names
ClusterCPUUsed --------------------> Field name
ClusterCPUUsed=31684 --------------------> Field values
31684 -------------------------> Expected output
ClusterCPUHALimit --------------------> Field name
ClusterCPUHALimit=383880 --------------------> Field values
383880 -------------------------> Expected output
HARamGBLimit --------------------> Field name
HARamGBLimit=589 --------------------> Field values
589 -------------------------> Expected output
ClusterMemUsedGB --------------------> Field name
ClusterMemUsedGB=201 --------------------> Field values
201 -------------------------> Expected output
Now i am able to get the numeric values alone when i use ltrim command, but the values after ClusterCPUUsed= keeps changing, is there any way to read all the values when we are using ltrim or any other command. Kindly help
| eval CPUUsed=tonumber(ltrim("ClusterCPUUsed=10145", "ClusterCPUUsed="))