Forums

ASP

This topic is locked

a little of topic

Posted 01 Oct 2005 07:06:30
1
has voted
01 Oct 2005 07:06:30 steve hiday posted:
ok, i have a list of over 750 email addresses that are in a word document
they are arranged in a long list like;




ect.
ect.

my question is, how do i insert a comma after all of these addresses without actually going through and clicking and hitting comma 750 times

i want it to look like this;

,
,
,
ect.
ect.

thank you for reading this and I hope you can help me out

Replies

Replied 01 Oct 2005 13:54:36
01 Oct 2005 13:54:36 Michael Behan replied:
Find and replace! Not sure if the ms word find and replace tool can do this (find returns) but others can.

Find all "
"
and replace with ",
"

You could also try copy/pasting them into excel (or maybe you can do this in word) and exporting the list as a comma delimited CSV file... then pase back into word.

If you are doing this so you can import into a database you should be able to tell it to use returns (instead of commas) to seperate items.
Replied 01 Oct 2005 18:09:37
01 Oct 2005 18:09:37 steve hiday replied:
That did not work as you said, however,
I DID FIND A SOLUTION,

using find/replace I told word to find" .com " and replace with " .com, "

did the same with .net and .org
thanks for the suggestion
Replied 04 Oct 2005 01:01:45
04 Oct 2005 01:01:45 Lee Diggins replied:
Hi Steve

Lucky they all ended with .com, you could have used ^p which is the code for a paragraph mark, if I remember rightly. I usually use Excel for that kind of stuff, trim to remove spaces then concatenate function.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

Reply to this topic