- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
csv lookup number vs string
dglass0215
Path Finder
09-30-2020
09:39 AM
I have a csv lookup that has a column with numerical data (specifically integers). When I do the lookup, splunk is treating it as string data. For example if I use this column to sort the numbers 1,2,3,10,11 it sorts as 1,10,11,2,3.
Any help is appreciated.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
isoutamo
SplunkTrust
09-30-2020
10:07 AM
You can do e.g.
eval num = tonumber(field_as_string)
There are also some other ways to do it, which you could found by goole.
r. Ismo
eval num = tonumber(field_as_string)
There are also some other ways to do it, which you could found by goole.
r. Ismo