0
First and last name in a field
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?
5 replies
-
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 -
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'
-
Thank you so much!
Content aside
- 4 yrs agoLast active
- 5Replies
- 2266Views