data4development / iati-workbench

Create IATI data files from a mix of spreadsheets and IATI input files.
https://developer.data4development.nl/iati-workbench/
GNU Affero General Public License v3.0
0 stars 1 forks source link

Add filter for "typical text in empty fields" such as "-" #28

Open rolfkleef opened 3 years ago

rolfkleef commented 3 years ago

When filling out spreadsheets or reports, people have a tendency to indicate a field is empty by using values such as “-”, “n/a”, “n.a.” and so on. We can add a filter to interpret those as intended to mean “empty value”.

This should work for typical value and codelist fields, but may have to be skipped for narrative fields? (To be researched)