Previously, in data load definition, I used rule type: plsql expression to transform upload data for a column from csv to a number column (below example). This option is no longer present, and I could not determine from the documentation, the correct way to utilize this function in the rule types/expressions. I am unsure how to utilize the new data profile replace expression/options to perform the same function for the new data load profile.
Previous format (legacy data load), it would transform the column to just the number section prior to the | symbol:
Column: A
RuleType: PLSQL Expression
Expression1: REGEXP_SUBSTR(:A, '[^|]+|?')
Example Input for column A: 111111 | Jarvis(Name)
Table Column A after data load: 111111