Split A Text Column By A Delimiter

Input collection: myContactNames16

FullNameEmail
Johnson, Brucebjohnson@outlook.com
Field, Sallysfield@hotmail.com
Nyugen, Samsnyugen@hotmail.com
Waters, Lauralwaters@outlook.com
Noble, Jackiejnoble@outlook.com


Output collection: mySolution16

FirstNameLastNameEmail
JohnsonBrucebjohnson@outlook.com
FieldSallysfield@hotmail.com
NyugenSamsnyugen@hotmail.com
WatersLauralwaters@outlook.com
NobleJackiejnoble@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"
    )
);