Extract

Extract a field from a record, CSV element or SQL field.

Phase

This instruction is used by the TapeTrack Import Engine.

Extract(field, offset, length, record);

Variable	Type	Description	Min Length	Max Length	Min Value	Max Value
field	String	The field to be set by this extraction.	1	128
offset	Integer	The zero based offset of the data to be extract, or the element index of a CSV element or SQL element. In the event that the data being processed is CSV based, a value of zero indicates that the raw CSV string should be extracted rather than an individual CSV element.	1	10	-214748364	2147483647
length	Integer	The length of the data to be extracted if the data is text based, or the maximum data length for CSV or SQL data.	1	10	-214748364	2147483647
record	Integer	The record within a header, if the value is non-zero and the data is text based. A record that is not a header if the value is zero and the data is text based. For CSV and SQL data this argument is ignored.	1	10	-214748364	2147483647

Extract VOLUME field from offset 10, length 6 of the body of a report.

Extract(VOLUME, 10, 6, 0);

Extract VOLUME field from the 2nd element of a CSV file.

SetCSVDelimiter(",");
Extract(VOLUME, 2, 6, 0);

Extract REPOSITORY field from offset 70, length 4 of the 3rd record of a header.

Extract(REPOSITORY, 70, 4, 3);