How can I validate a CSV field with a combination of predefined values?

[megin1989]

Hi,

I'm working with Frictionless to validate a CSV file, and I need to validate a field (shod_domain) against a predefined set of values. The set of allowed values is:

sdoh-category-unspecified
food-insecurity
housing-instability
homelessness
inadequate-housing
transportation-insecurity

The problem is that the field in the CSV file sometimes contains a comma-separated combination of these values. For example:

Homelessness, Housing Instability
I want to validate each value in the field to make sure that it's part of the predefined set. If there are any invalid values, I need to report them.

How can I implement this validation using Frictionless? Specifically, I would like to create a custom validation that checks if each comma-separated value in the shod_domain field belongs to the allowed set.

Any help or example code would be greatly appreciated!

Thanks!