Splunk Search

How to edit my eval statement to convert numerical values from a field into MB?

Path Finder

I have a field [B] that consists of some numbers and strings.

10 gb
20 gb 
30 gb 

I would like to implement a eval statement that would convert the numerical values into MB.

B=*"GB"| eval GB=*/1024 | table GB 

I'm not sure what is incorrect about this statement?

Tags (2)
0 Karma

Path Finder

if you have a 'string' field, first get the numeric value (i am using the rex command here)
then multiply the extracted value (field: numericB) with 1024 to get the MB...

| rex field=B "\D?(?<numericB>\d*)\D?" 
| eval MB=numericB*1024
| table MB
0 Karma
Get Updates on the Splunk Community!

Devesh Logendran, Splunk, and the Singapore Cyber Conquest

At this year’s Splunk University, I had the privilege of chatting with Devesh Logendran, one of the winners in ...

There's No Place Like Chrome and the Splunk Platform

WATCH NOW!Malware. Risky Extensions. Data Exfiltration. End-users are increasingly reliant on browsers to ...

Customer Experience | Join the Customer Advisory Board!

Are you ready to take your Splunk journey to the next level? &#x1f680; We invite you to join our elite squad ...