Check out Building a Data-Centric Culture at the ALMA Observatory on November 5th Read More

Clear incorrect cell for a date field

Dataiker
Dataiker
Clear incorrect cell for a date field
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.
0 Kudos
2 Replies
Dataiker
Dataiker
Hi Jeff, if you parse the date column, only the date with the format YYYYMMdd will be correctly parsed.
Mattsco
0 Kudos
Level 1
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)
0 Kudos
Labels (3)