worldbank / iefieldkit

Stata commands designed for Impact Evaluations field work. These are tools that are used during/after a survey in the field for data quality monitoring.
MIT License
39 stars 18 forks source link

[iecodebook] remove spaces in value label name #160

Closed luizaandrade closed 2 years ago

luizaandrade commented 4 years ago

Presence of spaces breaks the code when importing the choices sheet. I'm not sure how I ended up with spaces in there, but this seems simple enough to fix by removing leading and trailing spaces from the first column of the sheet.

luizaandrade commented 4 years ago

same for variable label

luizaandrade commented 2 years ago

This is still an issue. The error for having spaces on the survey sheet is informative: image

But the error for having blank spaces on the choices sheet is not: image

I think we should trim trailing and leading spaces from the choices columns in both sheets and then run these checks.

luizaandrade commented 2 years ago

resolved by #215