Custom Validation for CSV Fields
Closed this issue · 2 comments
How can I perform custom validation on a CSV file?
Example:
Validate that all combinations of the ENCOUNTER_CLASS_CODE and ENCOUNTER_CLASS_CODE_DESCRIPTION fields in the primary CSV file exactly match the data given in the validation file. The check should ensure that each pair of ENCOUNTER_CLASS_CODE and ENCOUNTER_CLASS_CODE_DESCRIPTION in the primary CSV exists in the validation .CSVS file using regular expressions.
version 1.0
@totalColumns 2
@Separator ','
ENCOUNTER_CLASS_CODE: regex("(?i)^(AMB|EMER|FLD|HH|IMP|ACUTE|NONAC|OBSENC|PRENC|SS|VR)$")
ENCOUNTER_CLASS_CODE_DESCRIPTION: regex("(?i)^(ambulatory|emergency|field|home health|inpatient encounter|inpatient acute|inpatient non-acute|observation encounter|pre-admission|short stay|virtual)$")
I don't really understand your question, as the example you have provided seems to solve it. Are you looking to say if the value scope of one field conditionally depends on the value of another field? If so this may help - https://digital-preservation.github.io/csv-schema/csv-schema-1.2.html#if-expressions
See digital-preservation/csv-validator/issues/502 for suggested schema that should achieve the desired result