I have a single long string - I'd like to split it into a list of unique keywords. Sadly, the database wasn't designed to do this, so I must do this in Python - I'm having some trouble using the .split() function, it doesn't seem to do what I want it to - any ideas?
thanks very much for your help. r-sr- longstring = 'Agricultural subsidies; Foreign aidAgriculture; Sustainable Agriculture - Support; Organic Agriculture; Pesticides, US, Childhood Development, Birth Defects; Toxic ChemicalsAntibiotics, AnimalsAgricultural Subsidies, Global TradeAgricultural SubsidiesBiodiversityCitizen ActivismCommunity GardensCooperativesDietingAgriculture, CottonAgriculture, Global TradePesticides, MonsantoAgriculture, SeedCoffee, HungerPollution, Water, FeedlotsFood PricesAgriculture, WorkersAnimal Feed, Corn, PesticidesAquacultureChemical WarfareCompostDebtConsumerismFearPesticides, US, Childhood Development, Birth DefectsCorporate Reform, Personhood (Dem. Book)Corporate Reform, Personhood, Farming (Dem. Book)Crime Rates, Legislation, EducationDebt, Credit CardsDemocracyPopulation, WorldIncomeDemocracy, Corporate Personhood, Porter Township (Dem. Book)Disaster ReliefDwellings, SlumsEconomics, MexicoEconomy, LocalEducation, ProtestsEndangered Habitat, RainforestEndangered SpeciesEndangered Species, Extinctionantibiotics, livestockAgricultural subsidies; Foreign aid;Agriculture; Sustainable Agriculture - Support; Organic Agriculture; Pesticides, US, Childhood Development, Birth Defects; Toxic Chemicals;Antibiotics, Animals;Agricultural Subsidies, Global Trade;Agricultural Subsidies;Biodiversity;Citizen Activism;Community Gardens;Cooperatives;Dieting;Agriculture, Cotton;Agriculture, Global Trade;Pesticides, Monsanto;Agriculture, Seed;Coffee, Hunger;Pollution, Water, Feedlots;Food Prices;Agriculture, Workers;Animal Feed, Corn, Pesticides;Aquaculture;Chemical Warfare;Compost;Debt;Consumerism;Fear;Pesticides, US, Childhood Development, Birth Defects;Corporate Reform, Personhood (Dem. Book);Corporate Reform, Personhood, Farming (Dem. Book);Crime Rates, Legislation, Education;Debt, Credit Cards;Democracy;Population, World;Income;Democracy, Corporate Personhood, Porter Township (Dem. Book);Disaster Relief;Dwellings, Slums;Economics, Mexico;Economy, Local;Education, Protests;Endangered Habitat, Rainforest;Endangered Species;Endangered Species, Extinction;antibiotics, livestock;Pesticides, Water;Environment, Environmentalist;Food, Hunger, Agriculture, Aid, World, Development;Agriculture, Cotton Trade;Agriculture, Cotton, Africa;Environment, Energy;Fair Trade (Dem. Book);Farmland, Sprawl;Fast Food, Globalization, Mapping;depression, mental illness, mood disorders;Economic Democracy, Corporate Personhood;Brazil, citizen activism, hope, inspiration, labor issues;citizen activism, advice, hope;Pharmaceuticals, Medicine, Drugs;Community Investing;Environment, Consumer Waste Reduction, Consumer Behavior and Taxes;Hunger, US, Poverty;FERTILITY, Women;Agricultural subsidies; Foreign aid;Agriculture; Sustainable Agriculture - Support; Organic Agriculture; Pesticides, US, Childhood Development, Birth Defects; Toxic Chemicals;Antibiotics, Animals;Agricultural Subsidies, Global Trade;Agricultural Subsidies;Biodiversity;Citizen Activism;Community Gardens;Cooperatives;Dieting;Agricultural subsidies; Foreign aid;Agriculture; Sustainable Agriculture - Support; Organic Agriculture; Pesticides, US, Childhood Development, Birth Defects; Toxic Chemicals;Antibiotics, Animals;Agricultural Subsidies, Global Trade;Agricultural Subsidies;Biodiversity;Citizen Activism;Community Gardens;Cooperatives;Dieting;Agriculture, Cotton;Agriculture, Global Trade;Pesticides, Monsanto;Agriculture, Seed;Coffee, Hunger;Pollution, Water, Feedlots;Food Prices;Agriculture, Workers;Animal Feed, Corn, Pesticides;Aquaculture;Chemical Warfare;Compost;Debt;Consumerism;Fear;Pesticides, US, Childhood Development, Birth Defects;Corporate Reform, Personhood (Dem. Book);Corporate Reform, Personhood, Farming (Dem. Book);Crime Rates, Legislation, Education;Debt, Credit Cards;' -- http://mail.python.org/mailman/listinfo/python-list