https://community.splunk.com/t5/Splunk-Search/Remove-spaces-in-result-of-format-function/m-p/533096#M150606 <P>I would like to make use of the format function to modify the results of a sub-search. I'm getting spaces in the output that are causing problems with my search.</P><P>I'm using CASE in the result to make the search case sensitive. My format function is:</P><LI-CODE lang="markup">| format "" "CASE(" "" ")" "OR name=" ""</LI-CODE><P>The output of my subsearch is:</P><LI-CODE lang="markup">CASE( "User 1" ) OR name= CASE( "User 2" ) OR name= CASE( "User 3" ) </LI-CODE><P>The extra spaces around the search term prevents the CASE function from working. Is there any way to remove these spaces?&nbsp;</P> Tue, 15 Dec 2020 06:28:51 GMT BernardEAI 2020-12-15T06:28:51Z https://community.splunk.com/t5/Splunk-Search/Remove-spaces-in-result-of-format-function/m-p/533096#M150606 <P>I would like to make use of the format function to modify the results of a sub-search. I'm getting spaces in the output that are causing problems with my search.</P><P>I'm using CASE in the result to make the search case sensitive. My format function is:</P><LI-CODE lang="markup">| format "" "CASE(" "" ")" "OR name=" ""</LI-CODE><P>The output of my subsearch is:</P><LI-CODE lang="markup">CASE( "User 1" ) OR name= CASE( "User 2" ) OR name= CASE( "User 3" ) </LI-CODE><P>The extra spaces around the search term prevents the CASE function from working. Is there any way to remove these spaces?&nbsp;</P> Tue, 15 Dec 2020 06:28:51 GMT https://community.splunk.com/t5/Splunk-Search/Remove-spaces-in-result-of-format-function/m-p/533096#M150606 BernardEAI 2020-12-15T06:28:51Z https://community.splunk.com/t5/Splunk-Search/Remove-spaces-in-result-of-format-function/m-p/533122#M150618 <P>This is a limitation of the the "format" command, I am not aware of anyway to prevent it adding spaces between the column/row separators/boundaries.</P> Tue, 15 Dec 2020 11:00:14 GMT https://community.splunk.com/t5/Splunk-Search/Remove-spaces-in-result-of-format-function/m-p/533122#M150618 nickhills 2020-12-15T11:00:14Z