DeDupe matching on case subject excluding reply indicator

[MarcDBehr]

Greetings.

I am trying to figure out if it is possible to duplicate cases using the dedupe module, looking for records, where the subject may contain a reply indicator. For example, example that these two subjects should be considered as potential duplicates:

• Why can't I log in?
• Re: Why can't I log in?

I looked at using the regular expression, but that doesn't seem to take into account matching on specific parts of the string. What I would like to use as the regular expression would be

([Rr]e:?)?\s*(.+)

I would also include other criteria for the matching rules, but it is the subject line that is causing the issue currently.

Is this possible?

Marc

[Pugs_Validity · Accepted solution]

Hey @marcae - Great use-case question. While I didn't have success with the regex, there's a more simple solve I think for you here. If you use the Cleaned Account Name Comparison Type, we can alter the rule to account for your regex. You'll need to make sure you have all iterations of Re:, RE, etc. added into your cleanse rules for Prefix Removal, then it will take care of what you are trying to accomplish. 

Cleaned Account Name: Uses built-in Cleanse rules to match similar names based on common punctuation, abbreviations, and common business prefixes and suffixes. These rules are customizable for language(s) and/or line of business.