title: Split the column to multiple column based on the three diff categories--new scenario
body: <p><a href="https://i.stack.imgur.com/mU8Xi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mU8Xi.png" alt="enter image description here" /></a>
  data need to get split from SOID column to Circ,Language,Words as show above in pic. When trying with below logic :-</p>
  <pre><code>SELECT SALES_ORDER_ITEM_DESCRIPTION,
   --regexp_substr(SALES_ORDER_ITEM_DESCRIPTION, 'Circuit:\\s([a-zA-Z0-9 ]*)(,\\s|$)', 1, 1, 'e') AS &quot;Circuit&quot;,
   --regexp_substr(SALES_ORDER_ITEM_DESCRIPTION, 'Language\\(s\\):\\s([a-zA-Z0-9, ]+)(,\\s|$)', 1, 1, 'e') AS &quot;Language&quot;,
   regexp_substr(SALES_ORDER_ITEM_DESCRIPTION, 'Circuit:\\s([a-zA-Z0-9 \\[\\] \\&amp; ]+)(,\\s|$)', 1, 1, 'e') AS &quot;Circ&quot;, 
  regexp_substr(SALES_ORDER_ITEM_DESCRIPTION, 'Language[()s]*:\\s([a-zA-Z0-9\\, ]+)(,\\s|$)', 1, 1, 'e') AS &quot;Language&quot;,
   regexp_substr(SALES_ORDER_ITEM_DESCRIPTION, 'Words:\\s([a-zA-Z0-9 ]*)(,\\s|$)', 1, 1, 'e') AS &quot;Words&quot;
  FROM XYZ;
  </code></pre>
  <p>the data is getting handled correctly, But as per the pic highlighted in red some data is not getting captured with the above logic. Instead of showing all languages it is picking only one language as English,where as I need the output as all the languages which are in column. Please need your inputs.</p>