Output Handling Parameters for Command Line

The following table describes the Output Handling parameters for command line.

Parameter

Description

Do

Defines the action for the Response parameters. Valid values:

  • Fail the job
  • Extract and handle data
  • Keep value in runtime parameter

Fail the job

Sets the job to fail.

Extract and handle data

Defines the data that is extracted from the output.

Keep value in Runtime parameter

Enables you to save the extracted value for future use.

Extract Data

Extracts data from one of the following:

  • Whole line
  • Match Regular Expression
  • Part of line
  • Columnar 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 start or end of a line by selecting from the drop-down lists the start and end positions of the text. You need to complete the X box to define the text.

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 Columnar 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)

Keep extracted data in Runtime parameter Name

Defines the name of the Runtime parameter where the extracted data belongs. Appears in Runtime Parameters in the Designer area.

Fail the job if extracted data

Defines how the data behaves if the job fails or succeeds.

Runtime Parameter

Defines the name of the Runtime parameter where the extracted data belongs. Appears in Runtime Parameters in the Designer area.