I have a vroom error when reading multiple csv files, the strange thing is that the code was made 9 months ago without any issues, so I am guessing something happened after package updates or Rstudio updates? How should I fix it? I am currently using Rstudio 4.3.1 (64-bit) Not able to provide an example because these are privacy protected large registry datasets.
library(vroom)
library(fs)
lmdb_files<-dir_ls(glob="*.csv")
lmdb_files
lmdb2005.csv lmdb1995.csv lmdb1997.csv lmdb1998.csv lmdb1999.csv lmdb2000.csv lmdb2001.csv lmdb2002.csv lmdb2003.csv
lmdb2004.csv lmdb2006.csv lmdb2007.csv lmdb2008.csv lmdb2009.csv lmdb2010.csv lmdb2011.csv lmdb2012.csv lmdb2013.csv
lmdb2014.csv lmdb2015.csv lmdb2016.csv lmdb2017.csv lmdb2018.csv lmdb2019.csv lmdb2020.csv
lmdb<-vroom(lmdb_files)
Fail in gsub("\"[^\"]*\"", "", lines) : input string 15 is invalid
In addition: Warning
In gsub("\"[^\"]*\"", "", lines) :
' to a wide stringate '"000001111111","EI",3/5/1997,1,,"00","Visk<f8>se ""DAK""","0,5%","S01",1,"PK","pakninger","BO",0.5,"PC",5