I want to select portions of a Phone number from a field called PhoneNumber, the numbers come in like example (343)765-58584 so i want to select three different portions from this number, namely: countryCode, AreaCode and the Number, even though the numbers do not contain the country code but i will like to add that as field just incase.
This what am expecting from the output

CountryCode|AreaCode|Number|

                 |343          | 767-58584