+ Start a Discussion
Vijay NagarathinamVijay Nagarathinam 

Blank space issue in validation rule

Hi All,

I want to remove white spaces from the given string. How to achieve this using the regular expression.

Example:
Salesforce Developer ==> I want to convert the string to like this "SalesforceDeveloper". Remove all white spaces from the given string.

Thanks,
Vijay
 
AvaneeshAvaneesh
Hi, Vijay,
you can use a validation rule to show you error using
CONTAINS(Description , ' ')
and to remove your space you can use a workflow rule using 
SUBSTITUTE(Description, ' ', '')
if this was helpful please let me know 
Thank you
Avaneesh Singh