Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Best way to correct tostring(,"duration") bug?
- 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
Hi there,
| eval session_length=tostring(end-start,"duration") is not padding zeros correctly (I believe just for seconds?): 02:08:4.275
What's the most elegant way to fix this?
The best I got so far is rex field=session_length "(?<hm>\d\d:\d\d:)(?<sn>\d\.\d\d\d)" | eval session_length=if(isnull(hm),session_length,hm."0".sn) which I'm pretty sure is breakable
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
rex field=session_length mode=sed "s/:(\d)(:|\.)/:0\1\2/g"
Give me karma
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Like this:
... | rex field=session_length mode=sed "s/(\d)(\.\d+)$/0\1\2/ s/:(\d)$/:0\1/"
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The one from @nick405060 is better.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe, I'm honestly not totally sure if it only effects seconds or not. If it does, then mine could be cleaned up because you don't need (:|.). If it only effects seconds and minutes, mine is good. If it effects hours mine needs to be modded.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If yours handles both 02:08:4.275 and 02:08:4, then yours is better, but if it doesn't, then mine is better (because it does both).
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
rex field=session_length mode=sed "s/:(\d)(:|\.)/:0\1\2/g"
Give me karma
Accelerating Observability as Code with the Splunk AI Assistant
Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...
Congratulations to the 2025-2026 SplunkTrust!
