Comparing two Long Text Fields

Question

Good morning,
Relatively new to Salesforce, so learning as I go at the moment.
We have an issue where the text from one (long text) field is being duplicated on another long text field in some records on a custom object.
I would like to be able to see records where the content in long text field A matches the content in long text field B. Formulas won't work, I believe, as I was hoping to create a custom field where when fielda__c = fieldb__c it's true or 1,and then create a report from that.
My second thought was perhaps to lift the first x characters from each field and match those somehow?
I'm hoping it's my newness to Salesforce that means I'm missing something obvious in being able to compare two text fields.
Any assistance is appreciated.

Answer 1

At the moment, isn't possible use long field in salesforce formula, so you need to do some workarounds to achieve your goal. Here some suggestions:

In Salesforce side you can create a boolean field and compare in the Apex the two long fields and valorize the boolean field or no, in this way you can filter by report in salesforce. (maybe you need to schedule this execution)

Other way is export the records (Dataloader, Salesforce Inspector, etc) with the Id column, and the two fields, compare them in excel, and do a mass update on the records that are equals. (manual process and necessary do each time that you need to compare them)

batch reference and examples: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_batch_interface.htm

schedule apex reference: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_scheduler.htm