I typically read in excel files with col_types = 'text' using read_excel because it makes scanning the data easier - but a problem I'm having right now is that I need to keep the data in its original format so I can preserve my dttmcolumns as dates and not excel date codes.
Typically, I run a scan for text like colSums(as.character(ing1 == 'STKMA')) looking to return the number of occurrence in each column which works fine when all columns are chrformat. I get the error:
character string is not in a standard unambiguous format
How do I accomplish my tasks around this like the above character search I usually perform? Thanks you (edited)