ProductCode = Split( Split(TypicalField,"(")(2) ,")")(0)
Be care with the Split! If you don't have enough sets of the search values you'll get "Subscript out of range".
The syntax of the split is a bit tricky. Help gives you:
Which makes you think you have to put it into an array. But if you add the index you can pick whatever you want and assign it to a variable:
The internal Split in the code sample gives you everything after the second "(", index (2). The external Split takes that value and drops off the ")" and everything after it.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group