search

bcgov / wqbench

R package to generate download and compile data from EPA ECOTOX database
Apache License 2.0
3 stars 2 forks source link

tab delimited file read issue #28

Closed aylapear closed 1 year ago

aylapear commented 1 year ago

Currently only the 3rd and 4th version will read in properly due to an error with the downloaded files

aylapear commented 1 year ago

Contact owners of data to see if they can correct for the next version release

aylapear commented 1 year ago 
Adding: ecotox table results
Error in scan(file = file, what = what, sep = sep, quote = quote, dec = dec,  : 
  line 265538 did not have 137 elements
aylapear commented 1 year ago

The | in the measure_comments column are causing the parsing issue as it takes them as columns instead of inside the quoted item

Screenshot 2023-04-05 at 2 46 13 PM

aylapear commented 1 year ago

done, updated quote character