https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618982#M215130 <P>Sorry, I am being stupid. '.' operator allows concatenation of numeric and alphabets while '+' allows only concatenation of alphabets and numeric.</P><P>Regards</P><P>Suman P.</P> Mon, 31 Oct 2022 17:12:50 GMT SumanPalisetty 2022-10-31T17:12:50Z https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618978#M215127 <P>Hi,</P> <P>Can we concatenate a string with a number using eval with '.' operator? I got to know that from a video, but when i do it, I am able to do it. I don't know what is going on. Kindly help.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="eval1.png" style="width: 953px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/22245i69CCE28DEF47C118/image-size/large?v=v2&amp;px=999" role="button" title="eval1.png" alt="eval1.png" /></span></P> <P>Regards</P> <P>Suman P.</P> Mon, 31 Oct 2022 19:13:13 GMT https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618978#M215127 SumanPalisetty 2022-10-31T19:13:13Z https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618980#M215129 <P>For some of your events the action field is null/not present</P> Mon, 31 Oct 2022 17:09:27 GMT https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618980#M215129 ITWhisperer 2022-10-31T17:09:27Z https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618982#M215130 <P>Sorry, I am being stupid. '.' operator allows concatenation of numeric and alphabets while '+' allows only concatenation of alphabets and numeric.</P><P>Regards</P><P>Suman P.</P> Mon, 31 Oct 2022 17:12:50 GMT https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618982#M215130 SumanPalisetty 2022-10-31T17:12:50Z https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618994#M215134 <UL><LI><DIV class="">The plus ( + ) operator accepts two numbers for addition, or <STRONG>two strings for concatenation.</STRONG></DIV></LI><LI><DIV class=""><STRONG>The period ( . ) operator concatenates both strings and number.</STRONG> Numbers are concatenated in their string represented form.</DIV></LI></UL><P>Check if the field "action" has null values. If it does, whole eval expression will be null. In stead, try like this :</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">source= "2access_30DAY.log" | eval "new_field"=coalesce('action',"Default String Here, change it per your need"). 10 | table "new_field"</LI-CODE><P>&nbsp;</P><P>&nbsp;&nbsp;</P> Mon, 31 Oct 2022 18:30:48 GMT https://community.splunk.com/t5/Splunk-Search/Is-it-possible-to-concatenate-string-with-a-number-using-eval/m-p/618994#M215134 somesoni2 2022-10-31T18:30:48Z