https://community.splunk.com/t5/Splunk-Search/csv-lookup-number-vs-string/m-p/522322#M147282 You can do e.g.<BR />eval num = tonumber(field_as_string)<BR />There are also some other ways to do it, which you could found by goole.<BR />r. Ismo Wed, 30 Sep 2020 17:07:32 GMT isoutamo 2020-09-30T17:07:32Z https://community.splunk.com/t5/Splunk-Search/csv-lookup-number-vs-string/m-p/522316#M147281 <P>I have a csv lookup that has a column with numerical data (specifically integers).&nbsp; When I do the lookup, splunk is treating it as string data.&nbsp; For example if I use this column to sort the numbers 1,2,3,10,11 it sorts as 1,10,11,2,3.</P><P>Any help is appreciated.</P> Wed, 30 Sep 2020 16:39:50 GMT https://community.splunk.com/t5/Splunk-Search/csv-lookup-number-vs-string/m-p/522316#M147281 dglass0215 2020-09-30T16:39:50Z https://community.splunk.com/t5/Splunk-Search/csv-lookup-number-vs-string/m-p/522322#M147282 You can do e.g.<BR />eval num = tonumber(field_as_string)<BR />There are also some other ways to do it, which you could found by goole.<BR />r. Ismo Wed, 30 Sep 2020 17:07:32 GMT https://community.splunk.com/t5/Splunk-Search/csv-lookup-number-vs-string/m-p/522322#M147282 isoutamo 2020-09-30T17:07:32Z