Perhaps this is really easy and I’m just not thinking straight or it can’t be done.
We imported several thousand accounts into SuiteCRM (I’m LOVING IT by the way). I noticed that we have MANY duplicate accounts that don’t have the same name. Unfortunately I don’t know how many. Here’s an example to two accounts that should be merged.
- AZ Dept of Corrections
- Dept of Corrections AZ
I’d like to do a regular string search for all accounts that have “AZ” at the end of the account name.
How can I search for this?