search

weecology / mcdb

Mammal community database updates
1 stars 1 forks source link

Interior quotes in the Notes field of the trapping table #4

Open dmcglinn opened 10 years ago

dmcglinn commented 10 years ago

Most of the rows of the Notes field in the trapping table do not contain quotes; however some rows contain sets of double quotes. As examples, for Site_ID 1212, we have the following Notes: "random placement of Sherman traps in ""area""", and for Site_ID 1461 we have the Notes: "sampling extent was 25 traps along ""standard lines""". Beyond just wanting greater consistency of formatting in the dataset, this kind of formatting becomes problematic when reading and writing the dataset into various programming languages (e.g., R) because the superfluous quotes may be accidentally stripped on import and export thus triggering an an apparent diff in git. My recommendation would be to drop all the interior quotes from the Notes field.

ethanwhite commented 10 years ago

+1

fluby commented 10 years ago

+1

dmcglinn commented 10 years ago

Sounds good I'll make this change and submit a pull request.