Hi,
Very useful package. Please consider setting the option comment.char="" by default in the function read_clip_tbl(). I just got bitten by this by copying a table from Excel, which I guess is a major use-case for this function, where the first column contained the value #N/A (Excel's standard NA value) which resulted in the whole line being ignored. I spent a very long time looking for the culprit before realising this.
clipr::read_clip_tbl("Header1\tHeader2\n#N/A\tVeryImportant\nR2C1\tR2C2")
# Header1 Header2
#1 R2C1 R2C2
clipr::read_clip_tbl("Header1\tHeader2\n#N/A\tVeryImportant\nR2C1\tR2C2", comment.char="")
# Header1 Header2
#1 #N/A VeryImportant
#2 R2C1 R2C2
Hi,
Very useful package. Please consider setting the option
comment.char=""by default in the functionread_clip_tbl(). I just got bitten by this by copying a table from Excel, which I guess is a major use-case for this function, where the first column contained the value#N/A(Excel's standardNAvalue) which resulted in the whole line being ignored. I spent a very long time looking for the culprit before realising this.