AnsweredAssumed Answered

Separating data

Question asked by gary1987 on Feb 5, 2009
Latest reply on Feb 7, 2009 by ralvy

Title

Separating data

Post

Thanks for solving my last question it worked well. Challenge is I have addresses in one database but the addresses all came in 3 or so different styles. All I want is the first and last, is there a functio I can write that will achieve this in one pass. The styles are all under one "Fullname" field but are as follows. I don't need middle name or Jnr etc.

 

Hopkins Gary

Hopkins Gary J

Hopkins Gary Jnr

 

These are the most common 

Outcomes