Split table field into two fields
I have a table with names - fields are Id and WholeName. I have (by exporting to Excel and then importing back) created a version of the table which now has Id, FirstName & LastName. I am now trying to find a way to modify the original table with the data in the new one. I have added the two new fields and thought I could use the Update Multiple Records function, but I can't see how. Is there a way to do this?
2 replies
-
Allright, I thought of a good idea for your problem. Let me show you.
Lets say you have a single text field with the full name, divide the first and last name with a space if you haven't already.
export the table into a csv file, then on excel, use text to columns to divide the first and last name using the space in the middle, now you should have two rows with the first and last name.
Now going back to Ninox, keep the full name field now untill we are done. Import the new modified csv file that we just now fixed and use another field for reference to import them in the correct spot. (Id, address, etc.)
Now delete the full name field and begin using the two First and Last Name Fields from now on. I Hope This Helped :).
-
Thank you for taking the time to give such a detailed reply! I have in fact managed to make the change internally using the built in 'split' function that I didn't know about but was suggested by Support. I was trying something like your method, but don't think I had it quite right ... if I need to do this again, will give it a try :)
Content aside
- 6 yrs agoLast active
- 2Replies
- 1958Views