splitrows col: column1 on: '\r'
split col: column1 on: ',' limit: 4 quote: '\"'
header
extract col: Item on: 'Fungicides'
extract col: Item on: 'Insecticides'
extract col: Item on: 'Herbicides'
extract col: Item on: 'Rodenticides'
extract col: Item on: 'Plant Growth Regulators'
extract col: Item on: 'Other Pesticides nes'
extract col: Item on: 'Seed Treatm Fungicides'
extract col: Item on: 'Seed Treatm Insecticide'
extract col: Item on: 'Mineral Oils'
extract col: Item on: 'Disinfectants'
drop col: Item
rename col: Item10 to: 'Disinfectants'
rename col: Item9 to: 'Mineral_Oils'
rename col: Item8 to: 'Seed_treatment_Insecticide'
rename col: Item7 to: 'Seed_treatment_Fungicide'
rename col: Item6 to: 'Other_Pesticide'
rename col: Item5 to: 'Plant_Grow_Control'
rename col: Item4 to: 'Rodenticide'
rename col: Item3 to: 'Herbicide'
rename col: Item2 to: 'Insecticide'
rename col: Item1 to: 'Fungicide'
merge col: Seed_treatment_Insecticide, Seed_treatment_Fungicide, Rodenticide, Plant_Grow_Control, Other_Pesticide, Mineral_Oils, Insecticide, Herbicide, Fungicide, Disinfectants as: 'column1'
rename col: column1 to: 'ALL_PESTICIDES'