0

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

null
    • Jorg
    • 6 yrs ago
    • Reported - view

    Hi, if you have only two words (firstname and lastname) in your WholeName field you can easily use the following formula in the Update Multiple Records funktion:

     

    for the firstname: "item(split(WholeName, " "), 0)"
    for the lastname: "item(split(WholeName, " "), 1)"

    You have to define item(split("your source field","delimiter (which is space here)","number of the part of the split string, starting with 0")

     

    Best regards, Jörg

    • sjdixey
    • 6 yrs ago
    • Reported - view

    Thanks, I think that will work for 95% of cases - I can adjust the remaining manually. I hadn't noticed the split function before ... looks useful!

Login to reply

Content aside

  • 6 yrs agoLast active
  • 2Replies
  • 2377Views