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