You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to TextWrangler Talk
Hi,
I downloaded a dataset from the internet in a CSV file format. I've tried to delete columns but each attempt results in the whole data in the spreadsheet to disappear. The columns of interest are the scientific name, the decimal longitude, and the decimal latitude. I don't know how to deal with that. I would greatly appreciate any helping hand in solving this issue.
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to TextWrangler Talk
Well, the file isn't a true CSV format. Each line/row is surrounded by double quotes, which would technically make it a one column file. Within each line is tab delimited instead of commas. So that makes some solutions not work as is.
If you only need to do this once then I'd simply open the file in a spreadsheet application like Excel or LibreOffice and just delete the columns and be done with it. If you need to do this programmatically then I'd start by deleting the quotes at the start and end of each line. You listed columns of interest, but I wasn't sure if those were columns you want to delete or the columns you want remaining after deleting the rest.