Ksenia, if this is, in fact, the full extent of the problem, just code it manually using substringcount. For example:
) as Field2
If your real data is more extensive (as I'm guessing is the case), take a look at Rob Wunderlich's QlikView Cookbook. Specifically, the mappingWithWildcards.qvw example.