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!

How to add a column in apex data load definition using regular expression in the selectors?

Nikita BafnaMay 18 2023

My CSV template has some columns which would be dynamic across different users. I am trying to add the data in a collection, however my collection doesn't accept data for those dynamic columns. My column name is c006 and c007 with selector type regular expression as REGEXP_SUBSTR(:C007, '^[a-zA-Z0-9_]*$') .However, file data doesn't load in those two columns.

Am I missing any setting? Please provide documentation if any.

Comments
Post Details
Added on May 18 2023
0 comments
1,030 views