I'm trying to import a bank statement. I've setup a data exchange definition and using dd-M-yy for my date format because the incoming data is in the format 01-Feb-21 for example. I get an error message though because it doesn't like the date format.
To bypass this I setup a transformation rule to replace "Feb" with "02" and that works, but I want it to also automatically translate Jan to 02, Mar to 03, etc. How can I setup this kind of replacement rule?
This is the transformation rule:
This is my field mapping:
these are my column definitions:
