...
- An empty input column value renders an empty array.
In the final row, the
matches on thed-s-itemlang item pattern "Y"value. To fix this, you can change the Pattern matching value to the following, which matches on two or more uppercase letters in a row:Code Block `{upper}{upper}+`
...
| Tip |
|---|
Tip: Additional examples are available in the above links for these functions. |
Break out Arrays
Expand arrays into rows
...
| D trans | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Results:
| num3 | nest2 |
|---|---|
| 13 | [11,12] |
| 13 | 13 |
| 16 | [14,15] |
| 16 | 16 |
| 19 | [17,18] |
| 19 | 19 |
...
| Info |
|---|
NOTE: Each element that you want broken out into a column must be listed on a separate line in Path to elements. |
Source:
| arrayNested |
|---|
| ["A",["B","C"],"D"] |
| ["H",["I","J",["K","L"]]] |
| ["E","F","G"] |
...
