engine:import:extract
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
engine:import:extract [2020/02/24 00:26] – Scott Cunliffe | engine:import:extract [2025/01/21 22:07] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 8: | Line 8: | ||
'' | '' | ||
- | // | + | ^ 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 | ||
- | |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 |
- | |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.| | + | < |
- | |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, |
+ | </ | ||
- | ==== Example ==== | + | Extract VOLUME field from the 2nd element |
- | **Extract: | + | < |
- | |Extract(VOLUME, | + | SetCSVDelimiter("," |
+ | Extract(VOLUME, | ||
+ | </ | ||
- | ==== Example ==== | + | Extract |
- | **Extract: | + | < |
- | |SetCSVDelimiter("," | + | Extract(REPOSITORY, 70, 4, 3); |
- | |Extract(VOLUME, 2, 6, 0);| | + | </ |
- | ==== Example | + | ===== See Also ===== |
- | **Extract: Extract REPOSITORY field from offset 70, length 4 of the 3rd record of a header.** | + | |
- | |Extract(REPOSITORY, | + | [[engine:import|Import Engine Functions]] \\ |
+ | [[cli: | ||
+ | [[cli: | ||
+ | |||
+ | {{tag> import_engine sync_engine}} |
engine/import/extract.1582504007.txt.gz · Last modified: 2025/01/21 22:07 (external edit)