topic Re: How to convert alphnumeric values to numeric values in Getting Data In

How to convert alphnumeric values to numeric values

sureshkumaar — Wed, 08 Sep 2021 09:14:13 GMT

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

Re: How to convert alphnumeric values to numeric values

PickleRick — Wed, 08 Sep 2021 09:37:44 GMT

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?

Re: How to convert alphnumeric values to numeric values

sureshkumaar — Wed, 08 Sep 2021 09:43:45 GMT

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

Re: How to convert alphnumeric values to numeric values

sureshkumaar — Wed, 08 Sep 2021 13:10:38 GMT

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="))