Substring

In the example on the right, the value -10 was entered directly for the Begin index. The returned section therefore starts with the tenth character from the end of the string passed as the input value.

For the Max. length parameter, a Variable value resolver is used so that at runtime the value of the maxCharacters variable is used to limit the length of the section

►NOTE◄ Starting from the direct input provided by default, the definition of a value resolver must be initiated by clicking on the small gray arrow at the bottom left of the input value (see Begin index in the screenshot). If 'no value' (from the context menu) is selected instead of a value resolver, the direct input appears again the next time the Substring value resolver is expanded.

To make it as easy as possible to adjust the 'segmentation' of the string as needed, the following configuration defines the desired length of the segments in question using a static string that can be interpreted as an array of integers in the JSON notation: [3,1,6,1,0]

The value 0 at the last position means that all characters after the 11-digit (3+1+6+1) container number should be output.

The JSON to object value resolver generates a list of integers from the static text, which can be processed in the header of a For each loop in the Resolver for entities parameter.

In the loop header, the Save String in variable parameter specifies that the input value (the string to be structured) is stored in the input variable. This variable allows access to the string within one iteration of the loop.

The screenshot on the right shows a Set value event action in the action block for iteration, which is used to successively build the structured string for output in the output variable. For this purpose, a Concat strings value resolver is used (right), which appends another Substring from the variable input to the previous content of the variable output with each iteration.

The parameters in the Substring value resolver change for each iteration:

• The Begin index is read from a cursor variable, which is recalculated in the following step per iteration.

• As Max. length is the integer from the array defined in the loop header that is valid as the reference object for the respective iteration and that is returned by the Object property value resolver without specifying a field.

A space is inserted before each 'attachment' from the input variable (see position 2 in the Concat strings value resolver).

To eliminate excess spaces, the Trim value resolver is concatenated in two places:

• When concatenated with the Substring value resolver, the 'inner' Trim value resolver prevents a double space from appearing in the output before the description text, which is already separated by a space in the input.

• The 'outer' Trim value resolver below the Concat strings is essentially used to eliminate the leading space before the first segment, which occurs because the output variable in the first iteration does not yet contain a character.

The cursor variable is used to define the starting point for each next iteration. This achieves another Set value event action, in which the number of characters taken over in the current iteration (see the segment variable in the Calculate value value resolver) is added to the previous cursor value. The 'value' of this sum defines the Begin index for the next section to be copied. It is assigned to the cursor variable.

►IMPORTANT◄ The output and cursor variables used in the loop should be initialized with the $null and 0 values, respectively, before the start of the loop, otherwise 'presets' of these variables can falsify the result.