AnsweredAssumed Answered

Separating data

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


Separating data


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