I have a data file with the first column "Site", which contains 3 sites for the data. I need to split these data by site so that I have three files - site 1, site 2, and site 3.
My thinking is that the format of the columns is problematic: Uneven column formatting
I tried to perform a function that would split the file based on the first column by value, but it just generated a slew of incorrect files.
Any tips? Thanks!
I tried to perform a function that would split the file based on the first column by value, but it just generated a slew of incorrect files. My expectation was that this would split the original file by site.
Any tips? Thanks!
