Execute VB Script
Description
Use the step to execute any VB Script. Write the script using value, StdOut object to generate output fields by using the specific syntax in the console. These generated fields can be used in subsequent steps at runtime.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of the step; This name has to be unique in a single workflow |
| Left Panel: | ||
| 1 | Get Input Fields | Click and select input fields from the list that can be used as a part of VB Script. |
| 2 | Write to Console | |
| 2.1 | Create StdOut Object | Click to create one new stdout object for VB Script. Syntax to create StdOut: objStdOut.WriteLine "<<>>FieldName::FieldValue<<>> Note: To use this option, the system must have wscript.exe installed, and its path must be added in the system's PATH environment variable. |
| 2.2 | Write Value to Console | Click to write output field and output value to console which can be used in subsequent steps. Syntax to write value: objStdOut.WriteLine "<<>>FieldName::FieldValue<<>>" |
| Right Panel: | ||
| 1 | VB Script | Console to write StdOut and value in VB Script. |
| Fields Tabel | The Fields table displays a list of output fields extracted from script. It also allows users to add metadata such as descriptive names for each field. | |
| 1 | Field Name | Displays name of the fields extracted from the script. for example, from ConsoleWrite ("<<>>FieldName::FieldValue<<>>") |
| 2 | Rename to | Optional new name for the field. Used when you want to display or reference the field using a different name. |
| 3 | Type | Select the data type of the field. Following are the type and available supported formats: Supported types are: - String - Date: Supported formats: - yyyy-MM-dd - dd/MM/yyyy - MM/dd/yyyy - dd-MMM-yyyy - yyyyMMdd - dd-MM-yyyy - yyyy/MM/dd - dd.MM.yyyy - MMM dd, yyyy - dd MMM yyyy - Boolean - Integer - BigNumber - Binary - Timestamp: Supported formats: - yyyy-MM-dd HH:mm:ss - yyyy-MM-dd'T'HH:mm:ss - yyyy-MM-dd'T'HH:mm:ss.SSSX - MM/dd/yyyy HH:mm:ss - dd-MMM-yyyy HH:mm:ss - Internet Address |
| 4 | Length | Specifies the length of the field: - Number: Total number of significant digits - String: Maximum number of characters - Date: Length of the printed date output |
| 5 | Precision | Specify the number of digits to display after the decimal point. This applies only to numeric types. - Number: Defines floating-point precision. - Other types: This setting is not used. |
| 6 | Replace value ‘Fieldname’ or ‘Rename to’ | Select Y (Yes) to find an existing field in the input stream that matches Fieldname and replaces its value. Select N (No) to add a new field to the output stream. |
| Action Button | ||
| 1 | Get Output Fields | Click Get Output Fields to see all output field details in table. When the Get Output Fields is clicked, the tool scans the entire script and looks for statements in the following format: objStdOut.WriteLine "<<>>FieldName::FieldValue<<>>" It parses these statements, extracts the FieldName, and populates the Fields table accordingly. |