The Parse Text The Parse Text tool extracts specific data from variables populated by other steps and then maps the data to other variables for use in further steps. tool does not require any global configuration; it can be immediately added to a task.
To add a new Parse Text step to an existing task:
- Open the relevant task (if creating a new task, see How to Create a Basic Task).
- Either:
► | Click and drag the Parse Text icon from the Task Browser to the task Design area. |
–OR–
► | From the task's Design tab, right-click on empty space and select New > General > Parse Text. |
- In the General tab, Name your task step.
- Go to the Main tab and Add parsing rules.How Do I Do This?
► Name — Enter a unique name for this rule ► Type — Provides the following rules: ■ Extract between [C1] and [C2] — Extracts the text between the first occurrences of specific values, in the specified order ■ Extract between word [N1] and word [N2] — Extracts the text between the first occurrences of specific words, in the specified order ■ Extract lines [N1] to [N2] — Extracts the lines of text between two line numbers inclusive ■ Extract after [C] to the end of line — Extracts the text after the first occurrence of a specific value to the end of the same line ■ Extract after word [N] to the end of line — Extract the text after a specific word to the end of the same line ■ Extract word [N] — Extracts a specific word ■ Extract after word [C] — Extract the text after a specific word ■ Extract after word [N] — Extract the text after a specific word (allows for a second rule of the same type) ■ Extract before word [C] — Extract the text before a specific word ■ Extract before word [N] — Extract the text before a specific word (allows for a second rule of the same type) ■ Move to start — Move the cursor back to the start of the data ■ Move to start of line [N] — Move the cursor to the start of a specific line number ■ Move to end of Word [C] — Move to the cursor to the end of a specific word ■ Move to start of Word [C] — Move to the cursor to the start of a specific word ■ Move to end of Word [N] — Move the cursor to the end of a specific word ■ Move to start of Word [N] — Move the cursor to the start of a specific word ■ Move to end of character [N] — Move the cursor to the end of a specific character ■ Move forward [N] characters — From its current position, move the cursor forward a specific number of characters ■ Move back [N] characters — From its current position, move the cursor back a specific number of characters ► Parameters — Insert the values for the selected rule ► Variable output — Choose the variable to save the selected text to ► Remove leading spaces — Removes any spaces included at the beginning of the extracted text For more information, see Adding New Rules.
-
Go to the Options tab and select the relevant error handling options for this task step.
How Do I Do This?The Options tab allows you to define how errors in this step are handled at task runtime.
If an error occurs, you can decide whether the step should Continue processing, or terminate the step immediately (Abort Step).
If the step is aborted, you can choose to Continue processing onto the next step in the task, or terminate the whole task immediately (Abort Task).
In Separators, list those word separators that may be used in the body of text you are parsing.
For more information, go to the main Options tab topic.
-
Click to save the task step.