Hello Folks,

My name is Pete,
and I am setting up an e-mail-list management solution for a
NPO.

I obtained a few hundred e-mail addresses in csv format.

The software I use to manage the lists require this format to import the addresses:
"One entry per line" (is there a technical term for that?

address1@oneperline.com
address 2@oneperline.com
etc.

Are there conversion tools that will convert my csv files
to the format above?

Thanks for your help!

Pete

any text editor with a find and replace


replace the comma with a carriage return

To add more to chrishirsts reply (which was a good one) you can get a free trial text editor here if don't have one:

TextPad

Open up your file, and then click on Search > Replace.

Then like chrishirts said - enter a comma in the space that says 'Find What', and '\n' (without the quotes) in the 'Replace With' area.

Then be sure to check the regular expression tick area.

Hey Chris and Codecrunch:

Aren't forums wonderful - MANY THANKS for both answers, which are going to save me a LOT of time!

I really appreciate you took the time to post your advice.

Pete

PS: I was waiting to get a notification when your posts posted, but maybe I just need to study my settings a bit more carefully..........and choose an option that will send me an e-mail each time I get a reply on a thread I started.........if anyone is up to briefly guide me to those settings........in case I don't see them readily, Thanks in advance.

Originally Posted by peteraloha

PS: I was waiting to get a notification when your posts posted, but maybe I just need to study my settings a bit more carefully..........and choose an option that will send me an e-mail each time I get a reply on a thread I started.........if anyone is up to briefly guide me to those settings........in case I don't see them readily, Thanks in advance.

Peter - You should be able to click on 'Thread Tools' above any thread, and then click the link that says subscribe to this thread. Then you'll get a few options of how to be notified. One of the options is ' Instantly be email'. I don't use it here - but it should work like you want.

Hi folks,

I figured out how to subscribe to this thread, I am all set with that.

I downloaded and installed Textpad, and important a block of several dozens of e-mail addresses in csv format.............needing them one per line as stated above.

Question: I tried to get them into a "block" the has the rows FULL, by backspacing in front of each row..............but somehow I don't manage to get the empty spaces out at the end of some rows.

Any suggestions, is it even necessary to have NO empty spaces on the right in any row?

Do I make sense, and is this a fair question for this forum?

Thanks,

Pete

I'm not sure I am understanding the question correctly. If you mean do you have to 'mash' them all together - no - so long as the regular expression has something consistent to match and replace.

For example - if you have this data

user101@a0000ol.com,
user102@a0000ol.com

You wouldn't need to put them like this in order to use the replace :

user101@a0000ol.com,user102@a0000ol.com

You would simply match and replace the comma with nothing. I would have to see the data in order to give you a more accurate reply. If you can post some 'fake' data in the same format - one of us might be able to help you better.

Codecrunch,

Thanks. Here is what I have:

user1@domain.com,user2@domain.com,user3@domain.com ,etc. etc..............chunks of e-mail adresses in csv format

What I need instead is one address per entry (is there a name for that?), and your earlier recommendations worked great on some smaller chunks of cvs data:
I pasted them into Textpad in cvs format, went to "search" and "replace", had it search for "," and replace it with "\n" without quotation marks, and bingo, I got what I wanted!

Now I used a larger chunk, maybe 160 addresses or more, and even though they were in cvs, there might be "empty space", as not all rows are filled up..........and when I started to try to bring it all together, it seemed like I was unable to get it all one continuous "block" of csv, with each row being fully filled.

Does that make more sense?............can I have "empty" space, or will that interfere with the process?

I am an absolute beginner with this subject, and all the input I received has been great!..............it motivates me to learn more, so I can be more effective and maybe some day tackle some more challenging db issues.

Mahalo,

Pete

codecrunch:

I believe I got it..............I was getting challenged by the WIDTH of the rows in TextPad, and when it returned the cvs addresses with the coma replaced by a
carrier return, I wouldn't see it initially, causing me to think it wasn't there, when in fact all I needed to do was scrolling to the left...............dough

Anyhow, folks, looks like I got it, and thanks again!

Pete