I had a first today - I was asked to prepare some data for an upload, and phone number was one of the fields. Unfortunately, the numbers needed to be divided into area code, prefix, suffix and extension. Ugh! Add to that some phone numbers were all numbers, while others had periods, dashes and/or parenthesis in them. So, I ended up using 2 methods to prepare it for a data upload. In this