Data Validator - allow null values
I’m trying to use the Data Validator snap to validate birthdays in a file.
The birthday (DOB) field is optional - it can be null, but if there is a date it needs to be in the proper format.
I hav...
Forum Discussion
Thank you @Spiro_Taleski. That would work, but I also need to run the Data Validator snap on other fields as well.
I have managed to work around the issue for now by using a Conditional snap before the Data Validator that checks for null values in the $DOB field and transforms them to an empty string ‘’. Then use the this regex that matches either an empty string or the date: ^$|\d{1,2}/\d{1,2}/\d{4}$
There is supposed to be a dollar sign $ after the caret ^ symbol in the regex above. Somehow it gets filtered out of the post.
