Say I have a date pattern to parse a field (column) like YYYYMMdd. How can I clear all the cells that do not match this pattern ? The default behaviour would be to discard any row that contain a cell that doesn't match the the above date pattern.
The default behaviour is to clear the cell. I was wrong to think the entire row was discarded.
In order to avoid warnings during the job execution, I used a workaroud with 2 steps in Recipe : - a regexp (clear non matching cell for YYYYMMdd : ((19|20)\d\d)(0[1-9]|1[012])(0[1-9]|[12][0-9]|3[01])) - then DSS (parse date)