If I import a list where first name and last name are in the same field, can I extract automatically the two names in two distinct fields?
You can attach this code to a button to do that.
let Names := ["", ""];
for n in select Table1 do
Names := splitx(n.FirstLastName, "\s");
n.('First Name' := item(Names, 0));
n.('Last Name' := item(Names, 1))
Is there a way to merge First Name & Last Name into a single "Name" column before export?
Thank You Sean!
@Kevin yes with a formula field you can with this formula: 'First Name' + " " + 'Last Name'