16 Aug
2009
16 Aug
'09
8:34 a.m.
The if statement can remain the same, add before it: if (SQL-GROUP =~ /(.*)-.*/) { update request { SQL-GROUP := "%{1}" } } This assumes that: a) There is never a '-' in the USUK or whatever part. b) You don't need to reference the original SQL-GROUP value. If you do, you may want to use something like: if (SQL-GROUP =~ /(.*)-.*/) { update control { Tmp-String-0 := "%{1}" } } if(control:Tmp-String-0 == "USUK") { ok } etc. --Mike