First and last name in a field
Ninox Profile

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?

Ninox Profile

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))
end

K

Is there a way to merge First Name & Last Name into a single "Name" column before export?

Ninox Profile

Thank You Sean!

Ninox Profile

@Kevin yes with a formula field you can with this formula: 'First Name' + " " + 'Last Name'

Reply