title: How to count the number of commas in a string?
body: <p>I use teradata. No access to functions, UDFs, stored procedures</p>
  
  <p>Table</p>
  
  <pre><code>id  attribute
  1   strength, power
  2   ring, wig, puff
  3   strength, ring
  4   puff, wig
  5   power
  </code></pre>
  
  <p>I need to count the number of attributes</p>
  
  <pre><code>id  att_number
  1   2
  2   3
  3   2
  4   2
  5   1
  </code></pre>
  
  <p>How can I do this?</p>