Hello. I Have an Excel file where one of the featuretype is NAME. It contains the full name of person. I need to split in three columns: Last Name, Middle Name and First Name

Hello, I'm working with a Excel file from an institution in México. It is a list of people, there is 22 registers.

It is like this:

In México, people's name is composed of three parts: Fiirst Name + Father's Last Name (FLN)+Mother's Last Name (MLN). Usually the register in an Excel Spreadsheet is: a column "Nombre" (NAME) then we can read in a row, for instance: "Pedro Antonio SANCHEZ HERNANDEZ". It is not useful for filtering using for instance Last Name.

So, I want to split this column and creating two news attributes: Apellido and Nombre. where Apellido will contain the Last Name and Nombre will contain First Name.

In the spreadsheet, the string begins with the Last Name = The FLN + MLN, then it comes the First Name, usually is a combination of two first names, eg: Pedro Antonio (Peter Anthony). There is a blank space between all the names.