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