Parsing Full Name fields

[AlexCuse]

Hi Guys,

I wrote an FAQ (faq705-6468) with a collection of functions to extract individual components from the dreaded 'Full Name' field. I would love to hear anyone's comments on it, particularly additional things to add to the lists of prefixes/suffixes and ways that the functions could be improved.

I will try to update it as I see new things (the dataset I've tested it on is only about 300 records, who knows what I will see in the future.

If you have time to take a look at it, I'd really appreciate the feedback.

Alex

A wise man once said
"The only thing normal about database guys is their tables".

 

[Remou]

The Very Reverend Dr Archie Craig, MC, DD
Sra, Sr,
M, Mme
Rt Hon
Mrs Justice
Lord
Vicount
The Fifth of that Ilk

 

[Remou]

More usefully:

http://www.dca.gov.uk/dept/titles.htm

 

[AlexCuse]

Thanks Remou, that will be helpful. I hope the Very Reverend Dr Archie isn't on my current list ;-)

A wise man once said
"The only thing normal about database guys is their tables".