title: Splitting one row in 2 column in bigquery
body: <p>trying to split the data in 2 columns with '/' delimeter. tried uising Split function but it did not work </p>
  
  <pre><code>SELECT
  s.siteid,
  s.notes, --This is the column that CSI uses for the description.
  split(s.notes,'/')  part1
  FROM AloomaTestBeta.SCSERVICES s
  </code></pre>
  
  <p>and also tried this one but gave me an Error: Array index 1 is out of bounds (overflow)</p>
  
  <pre><code>SELECT
  s.siteid,
  s.notes, --This is the column that CSI uses for the description.
  split(s.notes,'/') [OFFSET(0)] part1,
  split(s.notes,'/') [OFFSET(1)] part2
  FROM AloomaTestBeta.SCSERVICES s
  </code></pre>
  
  <p>here is the sample data</p>
  
  <p><a href="https://i.stack.imgur.com/uzLlD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uzLlD.png" alt="enter image description here"></a></p>
  
  <p>i am using this in Google biqquery and it's not working</p>