topic Re: truncate string with field calculator in ArcGIS GeoEvent Server Questions https://community.esri.com/t5/arcgis-geoevent-server-questions/truncate-string-with-field-calculator/m-p/46420#M198 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.esri.com/migrated-users/11300">Hwa Saup Lee</A>‌,</P><P></P><P>sorry, for sure trim is not what you are looking for but this should fit:</P><P></P><PRE class="language-none line-numbers"><CODE>substring(string, intIndexBegin, intIndexEnd)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P><SPAN style="color: #4c4c4c; background-color: #ffffff; font-weight: 300;">Best Stefan</SPAN></P></BODY></HTML> Thu, 08 Oct 2020 08:25:40 GMT Stefan_Jung 2020-10-08T08:25:40Z truncate string with field calculator https://community.esri.com/t5/arcgis-geoevent-server-questions/truncate-string-with-field-calculator/m-p/46418#M196 <HTML><HEAD></HEAD><BODY><P>How can I truncate string value into a certain length in the geoevent server?&nbsp; &nbsp; I am trying with field calculator with the following:&nbsp;</P><P>expression: LEFT([input_string_field],254)</P><P>target: Existing Field</P><P>Existing Field Name: definition, [input_string_field]</P><P></P><P>any suggestion?</P></BODY></HTML> Thu, 01 Oct 2020 07:29:16 GMT https://community.esri.com/t5/arcgis-geoevent-server-questions/truncate-string-with-field-calculator/m-p/46418#M196 Hwa_SaupLee 2020-10-01T07:29:16Z Re: truncate string with field calculator https://community.esri.com/t5/arcgis-geoevent-server-questions/truncate-string-with-field-calculator/m-p/46419#M197 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.esri.com/migrated-users/11300">Hwa Saup Lee</A>‌,</P><P></P><P>is "trim()" not what you are looking for?</P><P></P><P>Check out the documentation:</P><P><A class="link-titled" href="https://enterprise.arcgis.com/de/geoevent/latest/process-event-data/field-calculator-processor.htm" title="https://enterprise.arcgis.com/de/geoevent/latest/process-event-data/field-calculator-processor.htm">Field Calculator Processor—Process Event Data(10.8) | Dokumentation zu ArcGIS Enterprise</A>&nbsp;</P><P></P><P>Best Stefan</P></BODY></HTML> Mon, 05 Oct 2020 07:09:49 GMT https://community.esri.com/t5/arcgis-geoevent-server-questions/truncate-string-with-field-calculator/m-p/46419#M197 Stefan_Jung 2020-10-05T07:09:49Z Re: truncate string with field calculator https://community.esri.com/t5/arcgis-geoevent-server-questions/truncate-string-with-field-calculator/m-p/46420#M198 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.esri.com/migrated-users/11300">Hwa Saup Lee</A>‌,</P><P></P><P>sorry, for sure trim is not what you are looking for but this should fit:</P><P></P><PRE class="language-none line-numbers"><CODE>substring(string, intIndexBegin, intIndexEnd)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P><SPAN style="color: #4c4c4c; background-color: #ffffff; font-weight: 300;">Best Stefan</SPAN></P></BODY></HTML> Thu, 08 Oct 2020 08:25:40 GMT https://community.esri.com/t5/arcgis-geoevent-server-questions/truncate-string-with-field-calculator/m-p/46420#M198 Stefan_Jung 2020-10-08T08:25:40Z