title: Redshift get Word patterns from a String
body: <p>I have a string in a column <strong>'ABC1,ABC2,WWW1,WWW2,ABC3,WWW3,WWW4,ABC4'</strong>
  I need to extract words starting with ABC alone . The expected results should be </p>
  
  <p>ABC1,ABC2,ABC3,ABC4</p>
  
  <p>I tried the bellow but didnt work </p>
  
  <pre><code>select regexp_substr(split_part('ABC1,ABC2,WWW1,WWW2,ABC3,WWW3,WWW4,ABC4',',',1),'ABC[^"]*')
  </code></pre>
  
  <p>I am getting a the First occurrence only : as ABC1 . 
  How to get all occurrence of ABC*</p>