Andreas, this is a known problem if you're using a non-English Client. Put a space after 0. SUBSTRC($Version$, 0 , STRSTRC($Version$, ".")-1) The problem is, that the Admintool treats the second parameter as a number with a decimal separator and expects a number after the comma. So you can also write SUBSTRC($Version$, 0,0, STRSTRC($Version$, ".")-1) If you were using an english client your decimal separator is a . (dot) and you won't have this problem This is what BMC suggests in the admintool help.
Specifying arguments that use a comma as a decimal separator Specifying arguments that use a comma as a decimal separator (as is the case in a German locale, for example) requires special consideration for the following functions: * LPAD * RPAD * MAX * MIN * SUBSTR To specify an argument that uses a comma as a decimal separator 1. Use a hidden, read-only field, and assign a default value to it. 2. Use the appropriate field keywords as arguments. For example, instead of using SUBSTR($Character Field$, 56, 65) use SUBSTR($Character Field$, $Integer1$, $Integer2$) where Integer1 and Integer2 are hidden, read-only fields with default values of 56 and 65 assigned to them, respectively. The following table lists the functions you can use in a Set Fields action. IMHO this is a very crazy workaround for this problem. HTH Kind Regards Conny ________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Andreas Munch Gesendet: Dienstag, 7. April 2009 10:59 An: arslist@ARSLIST.ORG Betreff: SUBSTRC using 3rd parameter ** Hey everyone ARS 6.03.00 MSSQL 2005 Problem: Actually this proberbly is a novice question, but... I'm trying to remove the "."'s from the ARS Version information, pushing it to a Form containing users client version. This version information comes as a string eg. "6.03.00" or "7.1.00". For comparison of client versions I need to remove the "."'s from then string ending up with only digits which I then can assign to an integer field. I'm using then command (for the first part) SUBSTRC($Version$, 0, STRSTRC($Version$, ".")-1) but are getting an error message as: "Unexpected character (ARERR 2291) zIntVersionMajor [Assign line error at position 29]". If I'm trying to only provide the two first parameters I'm not getting the error message, but the third one is the error trigger. Trying to do other stuff it seems like I'm not allowed to use the 3rd parameter. What can be then mistake I'm doing while using the SUBSTRC function with all 3 parameters causing then error message? A. Munch __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"