one possibility would be to use the String Manipulation Node to get rid of all “;” at first and then use several Cell Splitter to split these cells. So you would have one Cell Splitter that splits according to "Address: " then you receive two new columns, one simply containing the address and one containing the remaining “Name: A B Phone: 1234”. Then use a second Cell Splitter on the column containing the name and phone only (so without the address) and split it according to "Phone: ". This assumes that the order will be always the same, so address is last, phone is next to last,…
Hi I made you a sample Workflow.
Basically I first split by semi column and than by double point. And in the end I pivot everything in a table.
Cheers, Iris