title: Extract type and phone number from string
body: <p>I have a varchar which can have these values:</p>
  <pre><code>&quot;Office: (415) 438-4437&quot;
  &quot;Office: (602) 740-6409 Fred Cohen&quot;
  &quot;Mobile: (707) 888-572&quot;
  &quot;Phone: (707) 472-0982&quot;
  </code></pre>
  <p>I need to separate these values as phone_type and phone columns.</p>
  <p>Should look like these</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>phone type</th>
  <th>phone</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Office</td>
  <td>(415) 438-4437</td>
  </tr>
  <tr>
  <td>Office</td>
  <td>(602) 740-6409</td>
  </tr>
  <tr>
  <td>Mobile</td>
  <td>(707) 888-572</td>
  </tr>
  <tr>
  <td>Phone</td>
  <td>(707) 472-0982</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Here my code</p>
  <pre><code>select phone from core.person;
  </code></pre>
  <p>I can have more data after the phone number, but Just need to pick the first word of the string which is the phone_type and the phone which is <code>(###) ###-####</code>, how to do that?</p>