read_Citavi_xlsx()

[SchmidtPaul]

Import like so:

import_path <- example_xlsx('3dupsin5refs.xlsx')
CitDat <- read_Citavi_xlsx(import_path ) 

• write function
• write tests
• write in example of README.Rmd
• use col_types = for all columns based on the Column Info Master of Column Info Master #5
• do we need str_replace_all(Categories, "\\s+", " ") for all text columns?
• prevent warnings Coercing text to numeric for setSuggestedColTypes = FALSE

[SchmidtPaul]

I think I remember finding non-standard whitespaces in some columns, most likely in Categories. This is not a problem per se but can be annoying when handling strings that seem to have " " in them, when in reality it is more complicated:

https://cran.r-project.org/web/packages/stringr/vignettes/regular-expressions.html

Should we get rid of all those special whitespaces as shown in the screeshot or could this potentially lead to unwanted consequences?

[SchmidtPaul]

CitaviR::read_Citavi_xlsx(path = "data-raw/diabetesprevalence.xlsx",
                          setSuggestedColTypes = TRUE)
#> Es gab 50 oder mehr Warnungen (Anzeige der ersten 50 mit warnings())

warnings()
#> Warnmeldungen:
#> 1: In read_fun(path = enc2native(normalizePath(path)), sheet_i = sheet,  ... :
#>   Coercing text to numeric in R6 / R6C18: '6'