I have a system which originally got account numbers from legacy system whose account numbers used zeros as a prefix. When the account numbers were brought into Salesforce the zeros were trimmed off and they do not exist in the Salesforce account ID.
Now we are being forced to refer to the old system for various reasons. So I need to figure out a way to match the current Salesforce account IDs with the original ones with the zeros.
If it were a matter of adding a specific amount of zeroes to the prefix of the Salesforce account IDs I wouldn't be sweating it. But some of the old accounts filled their zeros. So I have account numbers of an inconsistent type such as :
61260012418
60008030650
60015107804
Essentially, I want to trim the leading 6
and all of the zeros which immediately follow it. So my final numbers should be as such :
126001241
8030650
15107804
What would be the best approach for this ? If I could figure out a field formula to trim them then I could just import the entire IDs into Salesforce and trim off everything from the final 0 to the left. Does anybody know of any logic which could do that ?
If you knew of an Excel formula which could do it before I import it into Salesforce that would work too.