D F
asked on
How to make a list coma delimited
I have a list of emails in note pad and i want to make it coma delimited?
My list looks like this
email1@email.com
email2@email.com
email3@email.com
My list looks like this
email1@email.com
email2@email.com
email3@email.com
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Copy your list to Word, click Edit, Replace, in Find click Special, and select Manual Line Break. For With insert a comma (,) - and presto!
ASKER
admin@bla.com
info@gl.com
feedback@bea.com
snclr08@g.com
in word it looks like this
word 2007
I tried Manual Line Break it said nothing found
info@gl.com
feedback@bea.com
snclr08@g.com
in word it looks like this
word 2007
I tried Manual Line Break it said nothing found
Did you've tryed my solution? It works...
jppinto
jppinto
ASKER
yes it didnt give me a Delimiter option, im using 2007.
It worked for me! Maybe try:
Copy your list to Word, click Edit, Replace, More, in Find click Special, and select Manual Line Break. For With insert a comma (,) - and presto!
Copy your list to Word, click Edit, Replace, More, in Find click Special, and select Manual Line Break. For With insert a comma (,) - and presto!
Is there a reason your ignoring the script?
ASKER
no sorry Leew,
i havnt been able to set down long enough today to test it.can u tell me what a vbscript is?
i havnt been able to set down long enough today to test it.can u tell me what a vbscript is?
This is something Word does so much better that a bunch of script or code in Access.
vb - Visual Basic. Windows Supports scripts (various commands combined to complete a task). There are several types of scripts - Batch files are scripts. PowerShell Scripts, VBScripts, and others.
As I stated earlier, save the script to a .vbs file - then double-click or type the file name on the command line. I used a file name of "makecsv.vbs" but you can use "whatever.vbs"
Don't forget to change the paths for ReadFromFile and SaveToFile as noted below - I used the path "c:\temp\scripts" with the file names "makecsv.txt" and "makecsv.csv"
ReadFromFile="C:\temp\scri pts\makecs v.txt"
SaveToFile="C:\temp\script s\makecsv. csv"
NOTE: the lines in the script that start with a ' are comments - they could be deleted and NO EFFECT on the script functionality would occur.
To show you an example, see the picture/series of pictures below (note, in the picture below, I have removed all comments and blank lines so that it could fit in one graphic):
EE24332342.JPG
As I stated earlier, save the script to a .vbs file - then double-click or type the file name on the command line. I used a file name of "makecsv.vbs" but you can use "whatever.vbs"
Don't forget to change the paths for ReadFromFile and SaveToFile as noted below - I used the path "c:\temp\scripts" with the file names "makecsv.txt" and "makecsv.csv"
ReadFromFile="C:\temp\scri
SaveToFile="C:\temp\script
NOTE: the lines in the script that start with a ' are comments - they could be deleted and NO EFFECT on the script functionality would occur.
To show you an example, see the picture/series of pictures below (note, in the picture below, I have removed all comments and blank lines so that it could fit in one graphic):
EE24332342.JPG
ASKER
i tried word for some reason it didnt work
Note: in the above screen shot, I first "type" (which displays the contents) of the makecsv.txt file - which is a list of e-mail addresses, one per line.
Then I type the script - so you can see, with the exception of the file path, comments, and blank lines, it's exactly what I posted.
Then I run the script by simply typing the script name - "makecsv.vbs"
Then I list the files in the directory - you can see a new file, makecsv.csv
Finally, I type the makecsv.csv file and you can see that it is the same as the original makecsv.txt file, only it has a comma at the end of every line, EXCEPT the last line.
Then I type the script - so you can see, with the exception of the file path, comments, and blank lines, it's exactly what I posted.
Then I run the script by simply typing the script name - "makecsv.vbs"
Then I list the files in the directory - you can see a new file, makecsv.csv
Finally, I type the makecsv.csv file and you can see that it is the same as the original makecsv.txt file, only it has a comma at the end of every line, EXCEPT the last line.
Oh really - the script - and screen shot - would seem to work fine. ARe you familiar with scripting?
ASKER
leew i think what you are explaining may be a bit to advance for me, i havnt ever used vbscript
So? What's difficult? cut and paste the lines of code above into a file named "makecvs.vbs" - then look at the image I posted. (Click it to open it FULL SIZE).
It sounds like you're over-thinking this. Read what I wrote and follow the directions - YOU don't need to program - just enter the correct file locations and your done.
This little mole hill has become the proverbial mountain, and as such requires a lot more thought. Beyond me!
A relatively simple vbscript should work. Change the paths in GetFile and OpenTextFile (2nd and 3rd lines below) so that they properly reflect the path of your source data and where you want to save the new file.
This script can also be modified to accommodate multiple addresses on one line (assuming they are separated by a delimiter of some kind).
Save the script to a .vbs file - then double-click or type the file name on the command line. I used a file name of "makecsv.vbs" but you can use "whatever.vbs"
Open in new window