Differences

This shows you the differences between two versions of the page.

--- engine:import:extract [2020/02/24 02:49] – [Example] Scott Cunliffe
+++ engine:import:extract [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 8: / Line 8: @@
 ''Extract(field, offset, length, record);''
-//string field;//\\
+^ Variable ^ Type ^ Description ^ Min Length ^ Max Length ^ Min Value ^ Max Value ^
-//integer offset;//\\
+|field| String | The field to be set by this extraction.|1|128| | |
-//integer length;//\\
+|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|
-//integer record;//\\
+|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|
-|field| The field to be set by this extraction.|
+===== Example =====
-|offset| 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.|
+Extract VOLUME field from offset 10, length 6 of the body of a report.
-|length| The length of the data to be extracted if the data is text based, or the maximum data length for CSV or SQL data.|
+<code>
-|record| 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.|
+Extract(VOLUME, 10, 6, 0);
+</code>
-==== Example ====
+Extract VOLUME field from the 2nd element of a CSV file.
-**Extract: Extract VOLUME field from offset 10, length 6 of the body of a report.**
+<code>
-|Extract(VOLUME, 10, 6, 0);|
+SetCSVDelimiter(",");
+Extract(VOLUME, 2, 6, 0);
+</code>
+Extract REPOSITORY field from offset 70, length 4 of the 3rd record of a header.
+<code>
+Extract(REPOSITORY, 70, 4, 3);
+</code>
-**Extract: Extract VOLUME field from the 2nd element of a CSV file.**
+===== See Also =====
-|SetCSVDelimiter(",");|
-|Extract(VOLUME, 2, 6, 0);|
-==== Example ====
+[[engine:import|Import Engine Functions]] \\
-**Extract: Extract REPOSITORY field from offset 70, length 4 of the 3rd record of a header.**
+[[cli:sync_fields|Sync Engine Fields]] \\
-|Extract(REPOSITORY, 70, 4, 3);|
+[[cli:tmss10sync|TMSS10Sync]]
 {{tag> import_engine sync_engine}}