Example - regtab/RegTab-Wiki GitHub Wiki
Examples
📌 Example 1
📊 Source Table
Equipment | Reference data | Reference data | Passport details | Passport details |
---|---|---|---|---|
Transformer T-1 | Type | DEP-1600 | Full weight | 6680 |
Transformer T-1 | Factory num. | 406034 | Last M.R. date | 2005 |
Transformer T-1 | Defect data | none | ||
Transformer T-2 | Type | DEP-2400 | Full weight | 8480 |
Transformer T-2 | Factory num. | 555879 | Last M.R. date | 2005 |
Transformer T-2 | Defect data | none |
🧩 RTL Pattern
[[ATTR][SKIP]{4}]
[[VAL: SCHEMA=COL; RECORD=ROW; JOIN=(UP:@TEXT==THIS@TEXT)]
{[ATTR][@BLANK ? SKIP | VAL]}{2}]+
📊 Extracted Recordset
Equipment | Type | Full weight | Factory num. | Last M.R. date | Defect data |
---|---|---|---|---|---|
Transformer T-1 | DEP-1600 | 6680 | 406034 | 2005 | none |
Transformer T-2 | DEP-2400 | 8480 | 555879 | 2005 | none |
📌 Example 2
📊 Source Table
Mar | Aug | |
---|---|---|
Organic nitrogen, % | 0.05-1.26/0.27 | 0.04-0.32/0.18 |
Organic carbon, % | 0.18-2.69/1.39 | 0.40-3.40/1.73 |
Sulfide sulfur, mg/kg | 0.86-513.10/66.76 | 1.03-313.21/22.08 |
\ | ||
Context: Measurements from bottom sediment samples collected in 2022 at location "Solzan". |
🧩 RTL Pattern
[[SKIP][VAL: SCHEMA='MONTH']+]
[[SKIP][VAL: SCHEMA='MONTH']+][[(VAL: SCHEMA='INDICATOR' ',' VAL: SCHEMA='UOM')]
[(VAL: SCHEMA='MIN' '-' VAL: SCHEMA='MAX' '/' VAL: SCHEMA='AVE';
RECORD=(CELL;(ROW:C0);(COL:R0);'YEAR:2022';'LOC:Solzan';'SMPL:Sediment'))]+]+
📊 Extracted Recordset (example)
MIN | MAX | AVE | INDICATOR | UOM | YEAR | MONTH | LOC | SMPL |
---|---|---|---|---|---|---|---|---|
0.05 | 1.26 | 0.27 | Organic nitrogen | % | 2022 | Mar | Solzan | Sediment |
0.04 | 0.32 | 0.18 | Organic nitrogen | % | 2022 | Aug | Solzan | Sediment |
0.18 | 2.69 | 1.39 | Organic carbon | % | 2022 | Mar | Solzan | Sediment |
0.40 | 3.40 | 1.73 | Organic carbon | % | 2022 | Aug | Solzan | Sediment |
0.86 | 513.10 | 66.76 | Sulfide sulfur | mg/kg | 2022 | Mar | Solzan | Sediment |
1.03 | 313.21 | 22.08 | Sulfide sulfur | mg/kg | 2022 | Aug | Solzan | Sediment |
📌 Example 3
📊 Source Table
2000 | 2005 | 2010 | |
---|---|---|---|
Australia | 19028802 | 20176844 | 22031750 |
Austria | 8002186 | 8201359 | 8351643 |
Belgium | 10239085 | 10445852 | 10839905 |
🧩 RTL Pattern
[[SKIP][VAL: SCHEMA='YEAR']+]
[[VAL: SCHEMA='COUNTRY'][VAL: RECORD=(ROW{1};COL{1}); SCHEMA='DATA']+]+
📊 Extracted Recordset
DATA | COUNTRY | YEAR |
---|---|---|
19028802 | Australia | 2000 |
20176844 | Australia | 2005 |
22031750 | Australia | 2010 |
8002186 | Austria | 2000 |
8201359 | Austria | 2005 |
8351643 | Austria | 2010 |
10239085 | Belgium | 2000 |
10445852 | Belgium | 2005 |
10839905 | Belgium | 2010 |