[SalesForce] What are the functions can be used along with Text Area Field

I have a custom text field on custom object where i am using CONTAINS to check whether a particular string value is present in that text field or not, same CONTAINS if i try to use on TEXT AREA FIELD, it is not working as expected.

Is there any functions/methods available to check whether particular string value is present in TEXT AREA FIELD.??

Best Answer

CONTAINS does work on a LTA field. However, note that CONTAINS is cAsE-sEnSiTiVe, so you may need to also use UPPER or LOWER to make valid checks. All of the TEXT functions (LEN, LEFT, MID, RIGHT, SUBSTITUTE, CONTAINS, UPPER, LOWER, BEGINS, etc) should work. There are a few oddities, like ISBLANK doesn't seem to work correctly, but you can mostly work around those without Apex Code.

Related Solutions

[SalesForce] I need a String method in a Trigger to validate if a Rich Text Area is blank

You can remove all html tags (or just br if you want) and use isblank so that whitespace is not an issue.

String richtextstr = string.valueof(new_application_dependency_record.Application_Workaround__cApplication_Workaround__c);
richtextstr = richtextstr.replaceall('<.*>','');
string.isblank(richtextstr));

[SalesForce] Replace text in Rich text area field with trigger

Yes, APEX, the language used to write triggers, supports find and replace. String types (which include rich-text fields) have a number of options, primarily String.replace() and String.replaceAll() (see the String methods for the full list). You also use Pattern and Matcher classes that can do more complex regex related activities (see the Pattern and Matcher docs).

Basic Example

trigger YourTrigger on Solution (before update) {   
  for(Solution s : trigger.new) {
    s.replaceAll('Hello World','Goodbye World');
  }
}

More Info

If you're looking to explore what other functionality is available, you'll want to have the APEX API Reference handy.

Best Answer

Related Solutions

[SalesForce] I need a String method in a Trigger to validate if a Rich Text Area is blank

[SalesForce] Replace text in Rich text area field with trigger

Related Topic