This function scans a data frame for common problematic characters and returns a cleaned version by:
Converting smart quotes (e.g., curved) to ASCII quotes (e.g., " and ')
Replacing accented characters with ASCII equivalents (e.g., e, n)
Removing newline and carriage return characters (that create line breaks)
Examples
data(ExampleT)
ascii_check(DD.dict.T, DS.data.T)
#> $Message
#> [1] "ERROR: non-ASCII characters detected. See Information for details."
#>
#> $Information
#> file column row value issue_type
#> 1 Data dictionary VALUES 5 0=café Non-ASCII character
#>
DD.dict_updated <- ascii_cleaner(DD.dict.T)
ascii_check(DD.dict_updated, DS.data.T)
#> $Message
#> [1] "Passed: no non-ASCII characters detected in data dictionary or data set."
#>