Yes by using the STRSTR command you can determine where a string starts and then use it again for when it ends. These two variables are then used with substr to parse out the data you need.
-----Original Message----- From: Boylan, David <david_boy...@brown.edu> To: arslist@ARSLIST.ORG Sent: Wed, Jul 1, 2009 2:59 pm Subject: Setting Multiple fields from 1 Character field ** I have a character field in Form A that contains something like this: Name: My name Email: myem...@xxx Username: mine Phone: 555-9267 Wiki Title: Intro to Underwater Fire Safety Course ID: FIRE:2000:2009-Fall:S01 Purpose: For a class When to deactivate: Never Open to world: No Usernames: foo, bar, baz I want to set matching fields in Form B from this one character field – Name, Email, Username, etc. when a record is created in Form A. Has anyone had to do this? Thanks, Dave _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"