Sorry, spoke too soon. Here is the workflow that works for me:
Set Fields 1: Set 'TempInteger1'with: LENGTH($Full Name$)
Set 'TempInteger2'with: STRSTR($Full Name$, ",")
Set Fields 2: Set'First Name' with: RIGHT($Full Name$, ($TempInteger1$ -
$TempInteger2$) - 2)
Set 'Last Name' with: LEFT($Full Name$, $TempInteger2$)
Thanks to everyone for your great solutions!!
Carol
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
