Hi Mark,
Generally, based on file types, I would rename the CSV to txt, and open it in notepad.

Sent from a BrailleNote

Hi Linda,
You shouldn't need office to open a CSV file. I would try my advice, but I don't own a list. Although, I have worked and with, and have opened CSV files, I can manage with them.. If you would like, I could help with CSV generally off list.

Sent from a BrailleNote

There are several options that I've tried. Changing the extension to .txt allows me to open it in Notepad, but removing all the extraneous information is a pain.

Opening the file in Excel or Open Office Spreadsheet lets me delete the other columns easily. Then I can save it as a text file with just the first column. The procedure is a bit different for each program, but not too difficult to figure out. I can also do any other manipulation I might want, say email and user name only or sorting on a column.

I remember Yahoo having the option available to download only email addresses and could never figure out why it might be needed. I've always wanted at least the username along with it.

Duane

Hi Linda,
Ah, OK, that's why. I use speech, so by moving word by word, I can get the email addresses, or whatever I want to at the time, out of it. Or, better yet, import it to my address book, and go from there. Sorry that it didn't work for you.


Sent from a BrailleNote

Probably late on this - but the easiest thing I can think
of is to open Notepad or Wordpad, then use File->Open and
find the *.csv file. Works for me (Win 7).

Other is to open it in Excel, then use Save As - or if you
are on Office 365, it has an Export -> change file type ->
choose whatever is needed to upload wherever it needs to go.

dg

One other thing if it was not already mentioned is to right click on the file and choose open with and choose notepad. Note be sure that always use this program is unchecked with in this dialog box if you don't want to always open these files with the program you are choosing.

On 8 Sep 2015 at 21:58, Mark Fletcher wrote:

Someone is having an issue with the downloaded member list. They're
running Windows, and I'm on Mac, so unfortunately I can't help. They would
like to bring the member list into Notepad or Wordpad to edit (they just
want the email addresses out of the file), but they're having problems
because Windows doesn't think the .csv file is plain text.

Something else is going on. Windows handles the csv from groups.io just
fine. Notepad will open the csv, or you could rename to txt.

It shouldn't be the encoding. I think the file is UTF-8, but that shouldn't
cause a problem.

My guess is that when opening a file within Notepad, it filters all the files to
show only txt "Text Documents (*.txt)". A csv will not show up. There's a
pulldown to select "All Files (*.*)"

Wordpad's similar in that the Open File dialog filters for "All Wordpad
Documents". To show all files, just pull down to "All Documents".


But as has been said already, a spreadsheet or database manager will be
the easiest to deal with the column formats.

--
Jim
Poston@...

<< Pegasus Mail - best e-mail client, and it's free! >>

Mark,

Someone is having an issue with the downloaded member list. ... They
would like to bring the member list into Notepad or Wordpad to edit
(they just want the email addresses out of the file), but they're
having problems because Windows doesn't think the .csv file is plain
text.

It has been so long since I've run a Windows machine without Office installed that I'm not entirely sure of this, but it may be possible that their Windows system does not have a file association set up for the .csv extension. If Office were installed, files with that type would be associated with (automatically open in) Excel.

As Jim Ruby said, there ought to be a "Open With" button either in the download, or as a right-click on the downloaded file, which will allow the user to select Notepad or Wordpad. With that should be a checkbox to "Always use this program" for this type of file. Checking that (or leaving it checked) should set up the file association for future handling of .csv files.

Or, failing that, if you're trying to open the downloaded .csv from within Notepad you need to change the file type filter to *.* so that it will show you the .csv (and all other files).

Then there is the separate issue of extracting just the info you need from the file. I'll agree with those who've said that using a spreadsheet program is the easiest way, if you have such a program (and I can't imagine life without one).

Once you've got the file open in Notepad, the first problem with Groups.io's export is that it uses the unix-style line termination: just a LineFeed (U+000A). Notepad doesn't recognize those as new lines, so the rows of the export get mashed together. This should be taken as a bug report (or feature request) - the export should use (or offer) ASCII standard line termination - aka CRLF (U+000D, U+OO0A) for broadest interoperability.

Fortunately Groups.io's export has the email address as the first column, and the display name as the second. Which (had it not been for the line termination issue) would have made it relatively easy for the Notepad user to go down from line to line, deleting the unneeded information from the end of each line.

-- Shal

Linda,

Shal, you’ve hit the nail on the head!

In that case, you might try WordPad. It seems to accept the newline
format of groups.io's export. Then you have only the normal CSV
formatting to deal with (lots of quote marks and commas).

In WordPad you can also use the Save As command to save it as a "Text
Document - MS-DOS Format". That will give it the CRLF style of new line
so that Notepad will open that file as one line per member.

-- Shal


I wrote:

Once you've got the file open in Notepad, the first problem with
Groups.io's export is that it uses the unix-style line termination: just
a LineFeed (U+000A). Notepad doesn't recognize those as new lines, so
the rows of the export get mashed together.

Linda,

... I don’t think that list owners, previously from Yahoogroups, will
be pleased at having to go through all those hoops to get what, prior
to Neo, had been available with a single click (download). Just my
opinion...

Having a "lite" version of the Members list export, which gives only the
email addresses one per line (as in the Y!Groups classic "Download") is
certainly a feature request Mark can consider. I'd like to find a better
way to describe it though, as "Export" versus "Download" was not very
intuitive for many people (though it became pretty obvious once you
tried it).

The other difference here, versus Y!G classic, is this business of
having to download the file to open it, rather than having the plain
text simply appear in a browser page (where you could copy/paste or use
Save As, per your own preference). I'm not sure what the technical
considerations are, and certainly for groups with thousands of members a
copy/paste could be problematic, but for smaller groups it is nice to
remove the extra steps.

That said, I'm of the "but why would you ever want just the email
addresses?" camp. Because I don't understand it, I may not be the best
at describing what you want.

-- Shal