I have multiple text files (CSV) with a structure similar to this:
funkiana,23.55,-99.866 funkiana,24.634,-98.701 funkiana,24.717,-98.901 geminiflora,22.25,-104.6166667 geminiflora,21.21666667,-104.65 horrida,19.633,-97.367 horrida,23.61666667,-102.575 horrida,22.158,-100.979 horrida,19.506,-97.433 horrida,17,-97.56667 horrida,19.485,-97.263 horrida,19.017,-99.133 horrida,19.017,-99.15 horrida,18.91,-99.23 horrida,17.82167,-100.26333 horrida,19.507,-97.438 inaequidens,19.399,-99.314 inaequidens,23.58333,-105.8833 inaequidens,19.767,-103.7 inaequidens,20.787,-103.848
As you can see, there are three fields (species, latitude and longitude). Now, I want to split each CSV file into different CSV files, containing only the data of each species. In other words, I want a file for all the occurrences of
funkiana (with lat/lon), another for
geminiflora (with lat/lon) and so on.
Any ideas on how to do this? Maybe with a script or an Excel macro?