Split A Text Column By A Delimiter

Input collection: myContactNames16

FullName	Email
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	Email
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"
    )
);