You need to sign in to do that
Don't have an account?
Find area code of a phone number?
I need to extract the area code from the Account Phone field. Luckily, I really only need the data on North American accounts, so I'm thinking I could remove all non-number fields and then extract characters depending on what it starts with (if 011, then char 4 to 6, if 1, then char 2 to 4, else char 1 to 3). That would catch most cases but I can't believe there isn't code already out there for doing this. I've been searching all over to no avail. Are there functions I'm unaware of that could help? Anyone know of a better way to do this?
Hi, here is some code that I think will get you on your way, good luck.
All Answers
Hi, here is some code that I think will get you on your way, good luck.
Thanks SLockard!