Hi all,

We have a data field called #name#

Trouble is it contains all elements of the name, ie: First_Name Initials
Last_Name
(Note:  only about 30% have middle initials)

We would like to extract 
- the first word as their first name,
- the last word as their last_name
- and anything in between as their Initials

Anyone go a method to do this?

Thanks in advance

Rob
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to