truncate string with field calculator

Question

How can I truncate string value into a certain length in the geoevent server?    I am trying with field calculator with the following:

expression: LEFT([input_string_field],254)

target: Existing Field

Existing Field Name: definition, [input_string_field]

any suggestion?

Stefan_Jung · Answer

Hi Hwa Saup Lee‌, sorry, for sure trim is not what you are looking for but this should fit: substring(string, intIndexBegin, intIndexEnd)‍ Best Stefan

Stefan_Jung · Answer

Hi Hwa Saup Lee‌,

is "trim()" not what you are looking for?

Check out the documentation:

Field Calculator Processor—Process Event Data(10.8) | Dokumentation zu ArcGIS Enterprise

Best Stefan