Parsing Text

  • Thread starter Thread starter sbowman
  • Start date Start date
S

sbowman

I have a field with First Name MI Last Name. However, the middle
initial is not always present. How can I parse these into three
different fields? I've already looked on the Access Web and a bunch of
postings in the newsgroups, but most people seem to have a congruent
set of data. I unfortunately do not!!

Thanks,
Shelley
 
This can be very difficult at best. You might even have someone with a name
like Don van der Mark that will mess with things. If the number of records is
small, you could manually parse them or possibly add a bogus MI for those
missing one. Either way you'll need to check the work afterwards and fix
errors.
 
Back
Top