Extracting elements from a data string

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

RE: Extracting elements from a data string

Hi All, I'd like to thank all who took the time to put finger to keyboard on this one. Here's the code we ended up using to do this. Regards Rob #ListFirst(List1)#