Perform the Pre-Execute step before load operation

Enables you to execute a pre-execution step prior to the Load operation command line or Web Services.

Perform the Post-Execute Step after load operation

Enables you to execute a post execute step after the load operation command line or Web Services.

Command Line

Enables you to build the command line interface for the parameter. You build the command to be executed when you add a parameter to the command line field, which retrieves values from the external application.

Web Service

Enables you to build the Web Service for the parameter. You build the command to be executed when you add a parameter to the parameter value field to retrieve values from the external application. For Web Service parameters, see Text Box with load parameters - Web services.

REST API

Enables you to build the REST API interface for the parameter. You build the command to be executed when you add a parameter to the REST API field, which retrieves values from the external application. For more information about the REST parameters, see REST API parameters.

Extract data from lines

Defines which values are displayed after a load operation is executed. Values:

• Any
• Starts with
• Contains
• Ends with
• Matches Regular Expression

Extract Data

Extracts data from one of the following:

• Whole line
• Match Regular Expression
• Part of the line
• Column data

For more information see Examples: Extracting data.

Whole line

Extracts data from the whole line.

Match Regular expression

Enables you to match the expression by typing a pattern in the Pattern field.

You can view the text in the Preview line. You can change the preview text by clicking .

Part of the line

Enables you to extract data from the following:

Start Position: Start position of the line

• Beginning of line: Sets the start position at the beginning of line.
• X words after beginning of line: Sets the start position to X number of words after the beginning of line.
• X characters after beginning of line: Sets the start position to X number of characters after the beginning of line.
• X words before end of line: Sets the start position to X numbers of words after the beginning of line.
• X characters before end of line: Sets the start position to X numbers of words before the end of line.
• After specific text: Sets the start position after the first appearance of a specific text.
• Text to search: Sets the start position from this text.
• Include searched text: Includes the text to search in the extracted data

End Position: End position of the line

• End of line: Sets the end position to the end of line.
• X words after start position: Sets the end position to X numbers of words after the selected start position.
• X characters after start position: Sets the end position to X number of characters after the selected start position.
• Before specific text: Sets the end position before the first appearance of a specific text.
• Text to search: Sets the end position to before this text.
• Include searched text: Includes the text to search in your extracted data.

You can also do the following:

• Trim extracted data if it has preceding or trailing white spaces by clicking the checkbox.
• Preview the text in the Preview line. You can change the preview text by clicking .

Columnar Data

Enables you to extract Column data, when the output is column based, such as CSV format or SQL output format, by completing the following:

• Column Separator/s: Selects a separator for the column
• Column number: Defines the column number where you want to extract

Select the checkbox to Remove blanks (trim)