Hi!
I have a table with a column that is multiline and I am trying to divide that line and have the rest of the columns repeat, I have been trying for several days.
I have this
column a | column b | column c |
text 1 | text 2 | text3-1 text3-2 |
And I want to create a collection like this
column a | column b | column c |
text 1 | text 2 | text3-1 |
text 1 | text 2 | text3-2 |
Thank you very much Kirkby! it worked like a charm
Hi @ASDFASF
First, check if the SharePoint list uses char(10) for line feed.
If parsing using char(10) works, parse the whole list.
1)found out that SPO list uses char(10) for line feed.
2) Create ColParsed and fill the collection with parsed data from the columns ID(=columnA), Title(=columnB), and MultiLineColumn(=columnC), instead of using columnA, columnB, and columnC. I hope this won't cause any confusion
/* syntax for working with column columnA, columnB, and columnC is... */
ClearCollect(ColParsed,Blank());