Clear incorrect cell for a date field

[UserBird]

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.

[Mattsco]

Hi Jeff, if you parse the date column, only the date with the format YYYYMMdd will be correctly parsed.

[Jeff2C]

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)