title: Upload and parse file in Oracle APEX
body: <p>I'm trying to find the best way to upload, parse and work with text file in Oracle APEX (current version 20.1). Bussiness case: I must upload text file, first line will be saved to table A.
  Rest lines contains some records (columns are pipe delimited) should be validated. After that correct recordes should be saved to table B or if there is some error it should be saved to table C (error log).
  I tried to do something with the Data Loading wizard but it doesn't fit to my requirements.</p>
  
  <p>Right now I added a "File browse..." item to page, and after page submit I can find this file in <code>APEX_APPLICATION_TEMP_FILES</code> in blob_content.</p>
  
  <p>Is there any other option to work with that file than working with blob_content from <code>APEX_APPLICATION_TEMP_FILES</code>. I find it difficoult to work with type of data.</p>
  
  <p>Text file look something like that:</p>
  
  <pre><code>2020-06-05 info: header line 
  2020-06-05|columnAValue|columnBValue|
  2020-06-05|columnAValue||columnCValue
  2020-06-05|columnAValue|columnBValue|columnCValue
  </code></pre>