title: How do I split a string into two separate columns in Standard SQL (Google BigQuery)?
body: <p>I have a column that contains measurements in terms of length and width. Each entry in this column is written in the form lxw. I need to separate this column into two separate columns with one being length and the other being width. Please see below:</p>
  <p>This is my original column called &quot;size&quot;:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>size</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>930x570</td>
  </tr>
  <tr>
  <td>1460x700</td>
  </tr>
  <tr>
  <td>4x7</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to turn &quot;size&quot; into columns &quot;length&quot; and &quot;width&quot; as follows:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>length</th>
  <th>width</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>930</td>
  <td>570</td>
  </tr>
  <tr>
  <td>1460</td>
  <td>700</td>
  </tr>
  <tr>
  <td>4</td>
  <td>7</td>
  </tr>
  </tbody>
  </table>
  </div>