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

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?