FIO: Action Properties

Value

Data Type

Default Value

Description

FIO Command

SCRIPT/ABSOLUTE

SCRIPT

Command to set FIO operation. Possible values are SCRIPT or ABSOLUTE. ABSOLUTE enables the classic row-column addressing method where a file is in the conventional .csv format. SCRIPT enables the regular expression method of operation.

Column Number

Integer

Not Defined

The file column number where the action is to occur. (ABSOLUTE)

Delimitor

Character

,

Sets the file format delimiter. The default is a comma [,] if no other character is specified. (ABSOLUTE)

End Regex

Regular Expression

<NULL>

The end regular expression. (SCRIPT)

Output Format

String

Not Defined

The format of how the mapped list will be shown. This allows the input obtained via the mapped list to be re-ordered/re-formatted into a slot. For example, for a date-time field, if the mapped list was specified as follows:

Mapped List=s1=HH,s2=MM,s3=DD,s4=mm,s5=YY

then the slot output could be reformatted as:

Output Format=20YY-mm-DD HH:MM

(SCRIPT)

Include End regex

Boolean

TRUE

Includes the end regular expression. This is particularly useful where there are only two parts to the regular expression and the required data field is the second half of the regex. This allows the first part to be ignored, essential performing a quick data retrieval. (SCRIPT)

Include Start regex

Boolean

TRUE

Includes the start regular expression. This is particularly useful where there are only two parts to the regular expression and the required data field is the first half of the regex. This allows the second part to be ignored, essential performing a quick data retrieval. (SCRIPT)

Line Number

Integer

Not Defined

Specified the line number to look for the value/regular expression. (ABSOLUTE/SCRIPT)

Mapped List

String

Not Defined

The mapped List for the submatches (SCRIPT). Each matched field must be specified by:

s1=aaaa,s2=bbbb,s3=cccc,…sn=zzzz

where aaaa, bbbb, cccc, zzzz are mapped list known identifiers.

For example, if the input field was:

08,03 01,12,03

and the known format of the string was:

HH,MM DD,mm,YY

then the corresponding mapped list would be defined as:

Mapped List=s1=HH,s2=MM,s3=DD,s4=mm,s5=YY

Start Reg Exp

 

Not Defined

The Starting regular expression (SCRIPT)