You would create an active link or filter that would perform a set fields where you would set a temp field, in this case lets call it $tmpField$, to the function, strstrc($Full Name$, ",").
Then you would perform a second set fields where you would set the first name field, in this case $FirstName$, to: substr($Full Name$, 0, $tmpField$-1); And set the last name field, $LastName$, to: substr($Full Name$, $tmpField$+2) reason for the $tmpField$+2 is that we don't want the comma or space. I haven't tested this.. But should work as well. Bob Halstead -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carol Carnevali Sent: Wednesday, October 11, 2006 12:05 PM To: [email protected] Subject: Re: Parsing a Field Could you please give an example? Thanks. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
