Create a single column table from the pipebar delimited list (|)
TableFromList([List],[First Item As Header])
Where:
List is the list to convert to a single column table.
First Item As Header is whether to use the first item in the list as the header
| Rule | Result |
|---|---|
| TableFromList("Matt|Ian|Phil|Dave|Tom",TRUE) | This will return an array {"Matt";"Ian";"Phil";"Dave";"Tom"} |
| TableFromList(DWVariableNameList,FALSE) | This will return an array {"";"Matt";"Ian";"Phil";"Dave";"Tom"} |
| TableFromList(ListOfNamesReturn) | This will return an array {"";"Matt";"Ian";"Phil";"Dave";"Tom"} |
This is what the what the single column array produced by this function might look like when put into a Data Table Control.
| Matt |
|---|
| Ian |
| Phil |
| Dave |
| Tom |