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.