I want to extract the Second_Forename from the name column where I have already extracted Title, First Forename and Surname.
Title: If there is Mr, Miss present in the name than extract the Title or else Null
First Forename: The first word the title, if title is not present than the first word is the First_Forename
Surname: The last word in the name in the Surname
Second_Forename: Anything which is present in the name except Title, First_Forename and Surname.
The name column has varied count of words like 7 to 15 to 25 as well.
Please help:)
