Text Box with Load Operation Parameters

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

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

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.

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.

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.

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

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

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.

Extracts data from the whole line.

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 .

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 .