truncate string with field calculator

1696
2
10-01-2020 12:29 AM
Hwa_SaupLee
New Contributor III

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?

0 Kudos
2 Replies
Stefan_Jung
Esri Contributor

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

0 Kudos
Stefan_Jung
Esri Contributor

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

0 Kudos