Input collection: myContactNames16
FullName | |
Johnson, Bruce | bjohnson@outlook.com |
Field, Sally | sfield@hotmail.com |
Nyugen, Sam | snyugen@hotmail.com |
Waters, Laura | lwaters@outlook.com |
Noble, Jackie | jnoble@outlook.com |
Output collection: mySolution16
FirstName | LastName | |
Johnson | Bruce | bjohnson@outlook.com |
Field | Sally | sfield@hotmail.com |
Nyugen | Sam | snyugen@hotmail.com |
Waters | Laura | lwaters@outlook.com |
Noble | Jackie | jnoble@outlook.com |
Solution code:
\\Create a collection
ClearCollect(myContactNames16,
{FullName: "Johnson, Bruce", Email: "bjohnson@outlook.com"},
{FullName: "Field, Sally", Email: "sfield@hotmail.com"},
{FullName: "Nyugen, Sam", Email: "snyugen@hotmail.com"},
{FullName: "Waters, Laura", Email: "lwaters@outlook.com"},
{FullName: "Noble, Jackie", Email: "jnoble@ooutlook.com"}
);
\\Get split column by delimiter code
ClearCollect(
mySolution16,
DropColumns(
AddColumns(
myContactNames16,
"FirstName",First(Split(FullName,",")).Result,
"LastName",Last(Split(FullName,",")).Result
),
"FullName"
)
);