on 08-17-2014 9:25 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.