Multi line cell to several singel line cells
Hello!Im looking for a way to break out line items from at several row data set consisting of order numbers. Im thinking I should "paste" these order numbers (comes from another system were they are lumped in to several rows) in to a multi line field. In step 2 i need to break out each individual order number (one on each line) and get the individual orders number to populate one cell each. so - from one multi line cell to several one line cells.
I cant get it to work. Any ideas?
Thanks!
1 reply
-
You can use the split() function which will return an array. Something like this...
newArr := split(MultilineField, "
")
Use the count() function to get the total array items and use the item() function to access each array item. Note, arrays start with an index of 0.
https://ninox.com/en/manual/calculations/reference-of-functions-and-language
Content aside
- 4 yrs agoLast active
- 1Replies
- 619Views