title: Extracting Title, FirstName, MiddleName and LastName from Name field in Informatica
body: <p>I have a table with a name field which consists of a Title (optional), FirstName, MiddleName (optional) and LastName. All records have a FirstName and LastName but not all records have either a Title or MiddleName. For example: 
  Mr. Joey Tribbiani (no middlename) 
  Rachel Karen Green (no title) 
  Ms. Monica E Geller (all four fields) 
  Phoebe Buffay (no title or middlename) and so on </p>
  
  <p>The titles that I have on the table consists of either (Mr., Mrs., Ms., Ms, Sr., or Sra.)</p>
  
  <p>In this scenario, how do I separate the Name field according to the Title, FirstName, MiddleName and LastName in Informatica?</p>