search

kevinrae / mosskey

Multiple entry key for North American Mosses
0 stars 0 forks source link

need to escape backslashes \\ and singlequotes\' when importing into mysql #3

Closed kevinrae closed 6 years ago

kevinrae commented 7 years ago

Correction. Code seems to handle -()/;, OK. Needs more testing on \&.

kevinrae commented 6 years ago

Seems to need escaping when importing backslashes \ or single quotes \'

kevinrae commented 6 years ago

This isn't a bug per se. Rather a guideline for 'how to import data' into the mysql db. Perhaps consider a cell formatting rule in excel that tests for troublesome characters and warns (or escapes) them.

kevinrae commented 6 years ago

Addressed this by escaping within google sheets spreadsheet (moved excel file in to google sheets for collaboration).