Split A Text Column By A Delimiter

Input collection: myContactNames16

FullName	Email
Johnson, Bruce	[email protected]
Field, Sally	[email protected]
Nyugen, Sam	[email protected]
Waters, Laura	[email protected]
Noble, Jackie	[email protected]

Output collection: mySolution16

FirstName	LastName	Email
Johnson	Bruce	[email protected]
Field	Sally	[email protected]
Nyugen	Sam	[email protected]
Waters	Laura	[email protected]
Noble	Jackie	[email protected]

Solution code:

// Create a collection ClearCollect(myContactNames16, {FullName: "Johnson, Bruce", Email: "[email protected]"}, {FullName: "Field, Sally", Email: "[email protected]"}, {FullName: "Nyugen, Sam", Email: "[email protected]"}, {FullName: "Waters, Laura", Email: "[email protected]"}, {FullName: "Noble, Jackie", Email: "[email protected]"} ); // Get split column by delimiter code ClearCollect( mySolution16, DropColumns( AddColumns( myContactNames16, "FirstName",First(Split(FullName,",")).Value, "LastName",Last(Split(FullName,",")).Value ), "FullName" ) );Code language: JavaScript (javascript)