title: How do I parse the NULL value?
body: <p>I have a PIPE delimited file ( 3 pipes) which also has Null values. How do I pull the data including the NULL value from this example?</p>
  
  <pre><code>with data as
  
  ( select 'Abc|||KXG||||||CCC|||5/12/2014 12:12:22,DDD,EEE,FFF' str from dual)
  
  select REGEXP_SUBSTR (str, '([^|||]*)||| |$', 1, 3, NULL, 1 )  from data;
  </code></pre>