ccao-data / data-architecture

Codebase for CCAO data infrastructure construction and management
https://ccao-data.github.io/data-architecture/
6 stars 4 forks source link

Add comment about manual cleaning to `ccao-legacy.R` script #630

Closed jeancochrane closed 3 weeks ago

jeancochrane commented 3 weeks ago

As part of the ongoing exemption comparison work, I had to manually clean the file that represented an export of the OWNR table from the AS/400 to strip out some ASCII null characters that were being used instead of spaces (and thereby causing reader::read_fwf() to read the wrong column positions for those rows). This PR adds a single comment to the ccao-legacy.R script that processes that export to note for posterity that the export has been manually edited.