Text Segment

Extract text from a string value.

Input

Field Definition Type Required
text String from which text is extracted. String TRUE
start at

Position of the first character to extract from the string value in the text field, where 0 is the first character, 1 is the second, and so on.

If no value is provided in the end before field, then the first set of characters equivalent in number to the input value in this field will be extracted.

Number FALSE
end before

Position that is one greater than the last character to be extracted. If the value is greater than the length of the string in the text field, the entire string will be extracted.

If no value is provided in the start at field, then the first set of characters equivalent in number to the input value in this field will be extracted.

Number FALSE

Output

Field Definition Type
segment Extracted text segment. String

Example

text start at end before segment
Example 0 2 Ex
Example 2 null Ex
Example 3 5 mp
Example null 3 Exa

Related topics

Functions

Workflow elements