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"
