String Manipulation and cleaning data

I connect to a csv file and extract a list of first names

They are not cleaned and have examples like Title in the Firstname Mr or Miss

or Full stops in them, or they have two names like Steve White, where we want to split them up and put Steve as the first name and White as the last name.

If the firstname is Mr.Steve then we would want to put Mr in the title field and the update the firstname to Steve.

I know I can find things with RegEx but need a little bit of help to create the logic to split things up rather than just do one step