Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  • An empty input column value renders an empty array.
  • In the final row, the 

    d-s-itemlang
    itempattern
     matches on the "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
Typeref
p01Namecolumn
p01Valuenest2
SearchTermConvert Expand Array to Rowsrows

Results:

num3nest2
13[11,12]
1313
16[14,15]
1616
19[17,18]
1919

...

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"]

...