https://community.splunk.com/t5/Splunk-Search/How-to-trim-white-spaces-in-events-in-search-time/m-p/487417#M193833 <PRE><CODE>| foreach * [eval &lt;&lt;FIELD&gt;&gt; = trim('&lt;&lt;FIELD&gt;&gt;')] </CODE></PRE> <P>all fields are trimed without <CODE>_raw</CODE>.</P> Thu, 05 Mar 2020 01:41:44 GMT to4kawa 2020-03-05T01:41:44Z https://community.splunk.com/t5/Splunk-Search/How-to-trim-white-spaces-in-events-in-search-time/m-p/487416#M193832 <P>Hi,</P> <P>i have an event having white spaces in between i want to trim it <BR /> the data is coming from db connect i don't have access so i need o done it in search head</P> <P>Can some one help me in fixing this</P> Thu, 05 Mar 2020 01:16:58 GMT https://community.splunk.com/t5/Splunk-Search/How-to-trim-white-spaces-in-events-in-search-time/m-p/487416#M193832 vikram1583 2020-03-05T01:16:58Z https://community.splunk.com/t5/Splunk-Search/How-to-trim-white-spaces-in-events-in-search-time/m-p/487417#M193833 <PRE><CODE>| foreach * [eval &lt;&lt;FIELD&gt;&gt; = trim('&lt;&lt;FIELD&gt;&gt;')] </CODE></PRE> <P>all fields are trimed without <CODE>_raw</CODE>.</P> Thu, 05 Mar 2020 01:41:44 GMT https://community.splunk.com/t5/Splunk-Search/How-to-trim-white-spaces-in-events-in-search-time/m-p/487417#M193833 to4kawa 2020-03-05T01:41:44Z