Chemicals in Canadian Law

Save the following data as .csv, or when importing into data software, use "," delimited. Next, replace all "(COMMA)" strings with a "," character as needed (especially when searching websites).

The R code outlining this action is below. You need to insert your own text where it says string or apply it to a character vector containing strings.



 paste0( strsplit("string","\\(COMMA\\)")[[1]][1],",", strsplit("string","\\(COMMA\\)")[[1]][2])


fullname,url,legislationtype,enablinglaw,jurisdiction,scheduleY/N,associated documents,adURL
Cosmetic Regulations (C.R.C.(COMMA) c. 869),"http://laws-lois.justice.gc.ca/eng/regulations/C.R.C.(COMMA)_c._869/FullText.html",regulation,Food and Drugs Act,Federal,subsection 21.2(4),,
Controlled Drugs and Substances Act (S.C. 1996(COMMA) c. 19),"http://laws-lois.justice.gc.ca/eng/acts/C-38.8/FullText.html",act,,federal,Schedules I to VIII,,
Food and Drugs Act (R.S.C.(COMMA) 1985(COMMA) c. F-27),"http://laws-lois.justice.gc.ca/eng/acts/F-27/FullText.html",act,,federal,Schedules A to H,,
Transportation of Dangerous Goods Act(COMMA) 1992 (S.C. 1992(COMMA) c. 34),"",act,,federal,Schedule,,
Explosives Act (R.S.C.(COMMA) 1985(COMMA) c. E-17),,,,,CONVENTION ON THE MARKING OF PLASTIC EXPLOSIVES FOR THE PURPOSE OF DETECTION 1991,"http://www.unodc.org/pdf/crime/terrorism/Commonwealth_Chapter_11.pdf",
Chemical Weapons Convention Implementation Act (S.C. 1995(COMMA) c. 25),"http://laws-lois.justice.gc.ca/eng/acts/C-27.6/FullText.html",act,,federal,Annex on chemicals Schedule of chemicals schedules 1 to 3,,
Hazardous Products Act (R.S.C.(COMMA) 1985(COMMA) c. H-3),"http://laws-lois.justice.gc.ca/eng/acts/H-3/FullText.html",act,,federal,schedules 1 to 2,,
Import Control List (C.R.C.(COMMA) c. 604),"http://laws-lois.justice.gc.ca/eng/regulations/C.R.C.(COMMA)_c._604/FullText.html",,,,,"Convention on the Prohibition of the Development(COMMA) Production(COMMA) Stockpiling and Use of Chemical Weapons and on their Destruction","http://www.opcw.org/chemical-weapons-convention/download-the-cwc/"
Canadian Environmental Protection Act(COMMA) 1999 (S.C. 1999(COMMA) c. 33),"http://laws-lois.justice.gc.ca/eng/acts/C-15.31/FullText.html",act,,federal,schedules 1 to 6,,
"Consumer Chemicals and Containers Regulations, 2001 (SOR/2001-269)","http://laws-lois.justice.gc.ca/eng/regulations/sor-2001-269/FullText.html",Canada Consumer Product Safety Act,Federal,schedules_1_to_4,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,