LPAD or RPAD Validation Rule

Question

How to use LPAD or RPAD, I tried some examples from

LPAD( Account.Name , 2 )

Error: Formula result is data type (Text), incompatible with expected data type (true or false).

LPAD('my_company.com', 14, 'z')

Error: Formula result is data type (Text), incompatible with expected data type (true or false).

LPAD( Account.Name , 5 [, 'a'])

Error: Syntax error. Missing ')'

Return type is text or string, I am New to salesforce and Just want to know how these validation Rule works, just need an example to try it. — Aarya Tiwary, Commented Jan 23, 2017 at 6:34

Reshma · Accepted Answer · 2017-01-23 06:43:43Z

1

Create a formula field with return type as Text. LPAD and RPAD returns a text value not boolean. See the image below. From doc:-

LPAD inserts characters you specify to the left-side of a text string. RPAD inserts characters that you specify to the right-side of a text.

string. It will return output like this. Try with different values.

answered Jan 23, 2017 at 6:40

Reshma

4,0697 gold badges29 silver badges43 bronze badges

Add a comment |

1 Answer 1