It seems I must be a complete Bozo but I am not able to do this.
I need to export the data list, update a S2member custom field with a “1” for probably 100 users and reimport to update their status.
My problem is, no matter what program I use, I am not able to save a csv that properly maintains quotes around each field.
With Excel, if I simply open the csv, it strips the quotes. If I Import from text file to an empty sheet, the result can have quotes if the 'Text Qualifier" option is set to ‘None’ during import but no matter how I save the resulting file, it ends up with double quotes.
It seemed like the best option I might have had was to use Calc from Open Office but no matter what I did with the import dialog, the app would stop responding. I also tried Google Sheets and WPS Office. They both stripped the quotes.
I will add that I also tried exporting with the Pro ‘Advanced Import/Export Tools’ and found the resulting file to be rather jumbled with data in the wrong columns.
I presume I am doing something dumb?