title: How to do substring in hive when the string length is not known
body: <p>I'm trying to do a substring on a column to derive a value.</p>
  
  <p>My values in the column can be like: 
  <strong><code>(abcde), (qweryjj), (yehehsb)</code></strong>.</p>
  
  <p>I need to eliminate the brackets and just provide the values in the output So,
  I tried this: </p>
  
  <pre><code>substring(string,2,(length(string)))
  </code></pre>
  
  <p>But this is not working.</p>