Clear incorrect cell for a date field

UserBird
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.

Answers

  • Mattsco
    Mattsco Dataiker, Registered Posts: 125 Dataiker
    Hi Jeff, if you parse the date column, only the date with the format YYYYMMdd will be correctly parsed.
  • Jeff2C
    Jeff2C Registered Posts: 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)
Setup Info
    Tags
      Help me…