Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- tonumber() not working
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have an extracted field that is alphanumeric and splunk is interpreting it as a string, obviously. But I am using rtrim to remove the alpha characters and leave only numeric characters. But as I confirmed with if(isstr()) splunk is still interpreting the field as a string. So, I tried to convert to number with tonumber() but results are coming back null. Any suggestions?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't suppose you could give an example of the field? That would help immensely. I'm guessing it's something like "100 kWH"?
Have you confirmed that eval xx=rtrim(Total_Energy,"kWH") results in something that looks like a number? Is there a space in your "kWH" that I can't see and is there a space between the number and the string? A trailing space might make the rtrim output look not like a number and would be hard to see.
rtrim seems kinda like an odd choice, though it seems like it should work. Personally I would have used a regular expression with replace:
replace(Total_Energy, "^(\d+)", "\1")
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't suppose you could give an example of the field? That would help immensely. I'm guessing it's something like "100 kWH"?
Have you confirmed that eval xx=rtrim(Total_Energy,"kWH") results in something that looks like a number? Is there a space in your "kWH" that I can't see and is there a space between the number and the string? A trailing space might make the rtrim output look not like a number and would be hard to see.
rtrim seems kinda like an odd choice, though it seems like it should work. Personally I would have used a regular expression with replace:
replace(Total_Energy, "^(\d+)", "\1")
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That was the problem. I was forgetting about the space before the kWH. this worked correctly
eval xx=rtrim(Total_Energy, " kWH")
Thanks!!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
figured out a workaround from another post that converts my string to a number. Could there be a bug in tonumber()?
eval TE=strptime(rtrim(Total_Energy,"kWH"),"%s")
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Manage Edge Processor pipelines end to end with APIs
Splunk Brings Proof of Control to Digital Asset Transfers
Manage Ingest Processor pipelines end to end with APIs
