If the contents of your field from Form A will remain like that (a standard template), then it should be easy. You can use a combination of the functions STRSTR to find position numbers and SUBSTR to extract a part of the text, to get your desired results..
I had done something similar with the results of ipconfig /all in the past and Gidd has a posted example of what I had done on his website. You could use that as a reference. Cheers Joe ________________________________ From: "Boylan, David" <[email protected]> To: [email protected] Sent: Wednesday, July 1, 2009 2:59:57 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
