cancel
Showing results for 
Search instead for 
Did you mean: 

Error While creating a rule for trimming spaces

Former Member
0 Kudos

Hi All,

Please can you tell me the correct syntax for trimming the Spaces from the beginning of the word.

I tried like this but it is giving error as below:

BEGIN RETURN

ltrim($SPACES_TRIM, '');

END

ERROR:  The return statement is expected to return a conditional value: found type<VARCHAR>. (COR-10622)

Please do help me its urgent.

Thanks & Regards,

DJ

Accepted Solutions (1)

Accepted Solutions (1)

NielsWeigel
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Deepak,

when you create validation rules they always have to return TRUE or FALSE conditions. (A record can pass or fail your expression.

So your expression above returns a VARCHAR string, as you can read in the User guide, you are replacing leading nothing '' at the beginning of your string $SPACES_TRIM.

You need to understand basic concept for validation rule expressions and use of functions.

There are lots of great product tutorials here on the SCN, that describe scope, features and functionalities of Information Steward, so you got a understanding of what you can do with IS.


NIels

Former Member
0 Kudos

Hi NIels,

Thanks a lot for your reply.

Regards,

DJ

Answers (0)