Problem with SUBSTRING in proces

[robleer]

Hi,

I have a problem with SUBSTRING. I try to fill an attribute with a part of a string.

I added a rule like this (and call an UPDATE to run this rule on every object):

CustomFieldModel.Geboortedatum=CustomFieldModel.Value ////this works and returns a string of 15 characters which is to long

CustomFieldModel.Geboortedatum=SUBSTRING(CustomFieldModel.Value,0,4) ///this gives an error

I get:

java.lang.StringIndexOutOfBoundsException String index out of range: 4


When I Edit the biz object and just save it, the rule works fine. So it looks like SUBSTRING cannot run when called via an process???

Tia

Rob

[UnionSystems]

Perhaps the error occurs if the attribute is UNDEFINED? You could try changing to

Code: Select all

IF CustomFieldModel.Value IS DEFINED THEN CustomFieldModel.Geboortedatum=SUBSTRING(CustomFieldModel.Value,0,4)

[Jaymer]

I’m pretty sure I’ve never used a 0 in substring. Thought it starts at position 1. But I’m lying in bed. I could be wrong.

[BobK]

Rob,

SUBSTRING does work in a process,
and the index does start at 0 (sorry Jaymer).

You said that you are running your rule on every object, are you sure that Value is populated with 4 or more characters in every object? Have you tried what UnionSystems suggested?