Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX_STRING.SPLIT with Regular Expression on CSV file

DanePacDec 19 2019 — edited Dec 26 2019

An Excel CSV file can have comma separated tokens as well as quoted strings, with embedded commas.  I tried to come up with a regular expression that apex_string.split would deal with this, but could not discover one.  I had to resort to REGEXP but this would be much cleaner.

Thanks,

Dane

This post has been answered by Scott Wesley on Dec 19 2019
Jump to Answer
Comments
Post Details
Added on Dec 19 2019
4 comments
816 views