Skip to main content
Topics#Data ManagementPergunta de Vaughan Leiberum
Vaughan Leiberum perguntou em #Data Management
19 de set. de 2014, 11:44

Field Validation SUBSTITUTION

I would like to do a field validation on all open text fields which will remove/replace any carriage returns.

 

I've tried a number of ways, but having no success.

 

Is the following by anyway possible? 

 

I've tried creating a validation rule on a field in in Opportunities...replace a carriage return with a "|" (pipe). I've tried both \r and (br) for the carriage return

 

SUBSTITUTE(TestField__c, FIND("\r", TestField__c), "|")
1 resposta
  1. Marija Jovanovic (Salesforce)
    14 de out. de 2014, 00:27
    Hello Vaughan,

     

    I would like to try and help.  Here are some things to keep in mind when setting up Field Validation:

     

    (https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_defining_field_validation_rules.htm&language=en_US)

     

    (https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_validation_considerations.htm&language=en_US)

     

    (https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_validation_rules_tips.htm&language=en_US)

     

    I hope this information has been helpful.  If this has helped resolve your issue, please let us know by marking the post as "Best Answer" to help others in the community with similar questions.
Escrever uma resposta...
0/9000