Clear incorrect cell for a date field
Options
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
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.
Tagged:
Answers
-
Hi Jeff, if you parse the date column, only the date with the format YYYYMMdd will be correctly parsed.
-
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)
