Two lines in collection a single collection

Hi Guys,
I have two lines of data in one row of collection, I need to get both of the data lines separately,

I am attaching the screenshot below
 

Attachments

  • Capture.PNG
    37.3 KB · Views: 34

DanielTorres

New Member
you can iterate over the collection, using regex to filter to get the value of second line and put to another column the second line.
Don´t forget to remove the second line of the input column. (using this maybe, replace([coll.value], [SecondLineReturnedByRegex], ' '))

there must be better solutions than this, but this one works. Good luck ;)
 
Hey you can simple Iterate and and use split lines so it will be two rows in another collection.
Split lines will be available in Utility Strings.

Let me know if it can help you or not.
 
Top