Hello,
I am trying to do an upsert of over 3,500 contacts in Salesforce. There are over 500 instances of contact IDs that are essentially identical. For example: 0036A00000YIEfE and 0036A00000YIEfe are two different records. The only difference is the uppercase E and the lowercase e. How do I get either Excel to be case-sensitive or dataloader to be case-sensitive so the right records have the correct information inserted? Thanks!
Okay unfortunately for the file you've been given that ship has already sailed, so you would need to calculate what the ID-18 is using the Formula in the link. Unless you're just loading the file back to Salesforce, because like I said before, that Dataloader knows the difference between "e' and "E".
The Formula that I posted is a custom FIELD that you would create on each Object in your org (not a Report Formula)
