Strings Cut

Description

Strings Cut extracts a substring from a string field based on specified start and end character positions. Use this step when you need to pull out fixed-position data from structured strings — for example, extracting a date from a fixed-format filename, isolating a code segment from a composite identifier, or parsing specific characters from a fixed-width record. If the specified range falls outside the string length, the step returns a blank value.

Configurations

Field Name	Description
Step name	Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
In stream field	Name of the field whose substring to cut.
Out stream field	When a field name is given here, the step creates a new field with the substring. Otherwise the original field gets replaced by the substring.
Cut from	Designate where to begin cutting the substring. This value is 0 - based, thus the first character in a string is 0.
Cut to	Designate where to end cutting the substring. This value is exclusive (1-based), so using a 1 includes the first character. The maximum length of the new string is Cut to minus Cut from.