List several ways to get a list of lists
Let's take selectList by the Select field with multiple values.
Let's take a column from $rowlist[[lists]] where each row contains lists.
How do I quickly turn a list of lists into one list by connecting them one by one?
For this, listTrain is used — it concatenates lists into one list.
| id | field |
|---|---|
| 0 | ["a","b","c"] |
| 1 | ["d","e","f"] |
| 2 | ["h","j","c"] |
For example, such code based on this table:
=: listTrain(list: $sel)
sel: selectList(table: $#ntn; field: 'field'; order: 'id' asc)
// Result: ["a","b","c","d","e","f","h","j","c"]
How do I turn a list into text, with each item on a new line?
There is a function similar in name to listTrain — listJoin.
It performs a different action — it turns a list into text.
For example, if you need to send a list taken through selectList as text for printing, you can do this using listJoin.
In the str parameter, you can pass a glue — something that will join the elements of the list. If we want each subsequent element in the resulting text to be on a new line:
=: listJoin(list: $list; str: $#nl)
list: selectList(table: 'table'; field: 'field'; where: 'status' = "sold")
How do I turn delimited text into a list?
There is a reverse function strSplit, which turns text into a list, using separator.
For example, we have the value 23-4, which we obtained inside a cycle through:
=: str`$#nci + "-" + #id`
So the first digit in this value is the cycle number, and we need to get this number:
=: $split[0]
split: strSplit(str: #value; separator: "-")
And if we need the row number:
=: $split[1]
split: strSplit(str: #value; separator: "-")