How to extract "FIrst" & "Last" Names from a "Full Name" Field

[cheskiefisch]

Users enter their Full name in a field, but i want also the database to save “First” & “Last” name in separate fields.

How?

[fayewatson]

Hi @cheskiefisch this can be done by using regex:

[SOLVED] How do you extract "first name" from "full name" field?

OK! I just found out how to do it. I must be tired which is why it wasn’t working earlier. I was trying to use the :find and replace function with a regular_expression. I found one at this stack overflow thread. So when you pull out the Current User’s full name:find and replace press the “use a regexp pattern” insert this in the find: " .*(?:\n|$)" ( Be cautious, there is an important space in the beginning of that regexp ) leave the replace empty. That is it! It works.