How to split a customer full name into first and last name

Task

A file has a full_name column, for example Anna Petrova. The result needs first_name and last_name.

Short answer

Create two columns from one field: the first keeps everything before the first space, the second removes that first part and keeps the rest.

How to do it in Eofferix

Upload Excel or CSV and open the table editor.
Both output columns use the same full_name source field.
Create first_name from full_name and keep the first non-space part with a regular expression.
The first_name column uses a regular expression that keeps the first part before a space.
Create last_name from full_name and remove the first non-space part plus the following space.
Check names with middle names or compound surnames.

The data below is a training example and does not belong to real user files.

source data

client_id	full_name
C-1001	Anna Petrova
C-1002	Ivan Sergeev Smirnov

result

client_id	first_name	last_name
C-1001	Anna	Petrova
C-1002	Ivan	Sergeev Smirnov