topic Re: how to convert number to string using tostring function? in Splunk Search https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681636#M232929 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/254242">@LearningGuy</a>&nbsp;,</P><P>As I said, using 1000 instead of 1 you have a string.</P><P>I don't know why with a different number you have a different type.</P><P>You eventually could to try:</P><LI-CODE lang="markup">| makeresults | eval num = 1 | eval var_type = typeof(num) | eval num2 = tostring(num,"commas")." " | eval var_type2 = typeof(num2)</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Fri, 22 Mar 2024 05:33:11 GMT gcusello 2024-03-22T05:33:11Z how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681565#M232900 <P>Hello,<BR />how to convert number to string using tostring function?<BR />I tried using <STRONG>tostring</STRONG> function, but the result is still number<BR />See below.&nbsp; &nbsp;Thank you!!</P><LI-CODE lang="markup">| makeresults | eval num = 1 | eval var_type = typeof('num') | eval num2 = tostring(num) | eval var_type2 = typeof('num2')</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LearningGuy_0-1711035209226.png" style="width: 721px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/29838iCC195D4D279CDE06/image-dimensions/721x69?v=v2" width="721" height="69" role="button" title="LearningGuy_0-1711035209226.png" alt="LearningGuy_0-1711035209226.png" /></span></P><P>&nbsp;</P> Thu, 21 Mar 2024 15:35:39 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681565#M232900 LearningGuy 2024-03-21T15:35:39Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681567#M232901 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/254242">@LearningGuy</a>&nbsp;,</P><P>see at&nbsp;<A href="https://docs.splunk.com/Documentation/SCS/current/SearchReference/ConversionFunctions" target="_blank">https://docs.splunk.com/Documentation/SCS/current/SearchReference/ConversionFunctions</A></P><P>and try</P><LI-CODE lang="markup">| makeresults | eval num = 1 | eval var_type = typeof('num') | eval num2 = tostring(num, "commas") | eval var_type2 = typeof('num2')</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Thu, 21 Mar 2024 15:40:01 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681567#M232901 gcusello 2024-03-21T15:40:01Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681569#M232902 <P>Hello&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>&nbsp;,<BR /><BR />I tried and the same result..&nbsp; see below..&nbsp; thank you</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LearningGuy_0-1711035919488.png" style="width: 656px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/29839i30662818CE33E32A/image-dimensions/656x264?v=v2" width="656" height="264" role="button" title="LearningGuy_0-1711035919488.png" alt="LearningGuy_0-1711035919488.png" /></span></P><P>&nbsp;</P> Thu, 21 Mar 2024 15:45:38 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681569#M232902 LearningGuy 2024-03-21T15:45:38Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681570#M232903 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/254242">@LearningGuy</a>,</P><P>what does it happen running:</P><LI-CODE lang="markup">| makeresults | eval num = 1000 | eval var_type = typeof("num") | eval num2 = tostring(num, "commas") | eval var_type2 = typeof("num2")</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Thu, 21 Mar 2024 15:48:18 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681570#M232903 gcusello 2024-03-21T15:48:18Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681573#M232904 <P>They both became String.&nbsp; &nbsp; &nbsp;Num should be number.&nbsp; Thanks<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LearningGuy_0-1711036391407.png" style="width: 649px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/29840i3E7886E26188E0E0/image-dimensions/649x271?v=v2" width="649" height="271" role="button" title="LearningGuy_0-1711036391407.png" alt="LearningGuy_0-1711036391407.png" /></span></P><P>&nbsp;</P> Thu, 21 Mar 2024 15:54:01 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681573#M232904 LearningGuy 2024-03-21T15:54:01Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681574#M232905 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/254242">@LearningGuy</a>,</P><P>the second it's a string, you transformed it using the tostring function, infact you have the commas.</P><P>Ciao.</P><P>Giuseppe</P> Thu, 21 Mar 2024 15:56:36 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681574#M232905 gcusello 2024-03-21T15:56:36Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681578#M232906 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>&nbsp;<BR />Yes but why the first one is also string?<BR />The first one is number.<BR />Should I remove " " from typeof?&nbsp; &nbsp; &nbsp; &nbsp; Thanks</P><LI-CODE lang="markup">| makeresults | eval num = 1 | eval var_type = typeof(num) | eval num2 = tostring("num") | eval var_type2 = typeof(num2)</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LearningGuy_0-1711036912855.png" style="width: 606px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/29841iA435305632A53C26/image-dimensions/606x241?v=v2" width="606" height="241" role="button" title="LearningGuy_0-1711036912855.png" alt="LearningGuy_0-1711036912855.png" /></span></P><P>&nbsp;</P><P><BR />Thanks</P> Thu, 21 Mar 2024 16:02:08 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681578#M232906 LearningGuy 2024-03-21T16:02:08Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681579#M232907 <P>hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/254242">@LearningGuy</a>,</P><P>as I said, you have to say what kind of string you want:</P><LI-CODE lang="markup">| makeresults | eval num = 1 | eval var_type = typeof(num) | eval num2 = tostring(num,"commas") | eval var_type2 = typeof(num2)</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Thu, 21 Mar 2024 16:05:10 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681579#M232907 gcusello 2024-03-21T16:05:10Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681592#M232909 <P>Hello&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>&nbsp;<BR /><BR />Sorry.. I tried again your last suggestion, but <STRONG>num</STRONG> and <STRONG>num2</STRONG> still have type as <EM><STRONG>"Number"</STRONG></EM><BR />I expect <STRONG>num2</STRONG> has <EM><STRONG>"String"</STRONG> </EM>type after using&nbsp; &nbsp;<STRONG>num2</STRONG>= <FONT color="#FF0000"><STRONG><EM>tostring</EM></STRONG></FONT>(<STRONG>num</STRONG>,"commas")&nbsp;&nbsp;<BR />Please suggest&nbsp; &nbsp;Thanks again..</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LearningGuy_0-1711042200468.png" style="width: 718px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/29847iE6955E466E71195F/image-dimensions/718x289?v=v2" width="718" height="289" role="button" title="LearningGuy_0-1711042200468.png" alt="LearningGuy_0-1711042200468.png" /></span></P><P>&nbsp;</P> Thu, 21 Mar 2024 17:32:47 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681592#M232909 LearningGuy 2024-03-21T17:32:47Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681636#M232929 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/254242">@LearningGuy</a>&nbsp;,</P><P>As I said, using 1000 instead of 1 you have a string.</P><P>I don't know why with a different number you have a different type.</P><P>You eventually could to try:</P><LI-CODE lang="markup">| makeresults | eval num = 1 | eval var_type = typeof(num) | eval num2 = tostring(num,"commas")." " | eval var_type2 = typeof(num2)</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Fri, 22 Mar 2024 05:33:11 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/681636#M232929 gcusello 2024-03-22T05:33:11Z Re: how to convert number to string using tostring function? https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/693361#M235918 <P>It's a bit older but it seems to be some confusion around:</P><P>Your second example is completely different from the first one as you use double quotes, i.e.</P><P>&nbsp;</P><LI-CODE lang="markup">| eval var_type = typeof("num")</LI-CODE><P>&nbsp;</P><P>"num" is a literal string which has nothing to do with your variable! Take care about using double quotes (for strings), single quotes (for field names, e.g. containing spaces (for whatever reason... <span class="lia-unicode-emoji" title=":winking_face:">😉</span> )) or no quotes at all (also for field names).</P><P>Besides that to me it seems that this `tostring` function is buggy. If I convert any number using `tostring(number)` that should(!) become a string, regardless of any "format"-argument. And the "typeof()" function should then return "String" for this string.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bildschirmfoto_2024-07-15_11-33-23.png" style="width: 999px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/31758i76FA951349D0B4D8/image-size/large?v=v2&amp;px=999" role="button" title="Bildschirmfoto_2024-07-15_11-33-23.png" alt="Bildschirmfoto_2024-07-15_11-33-23.png" /></span></P> Mon, 15 Jul 2024 09:35:37 GMT https://community.splunk.com/t5/Splunk-Search/how-to-convert-number-to-string-using-tostring-function/m-p/693361#M235918 rvany 2024-07-15T09:35:37Z