comma delimited file to single column

rfigley

I've got a file of email addresses that was exported from and AOL address book. all teh email addresses are separted by a comma and a space. I want to convert it to a single column (each email address seperated by carriage return. What is the easiest way to do this?

TheDefender

Take a look at the following functions in the manual:
[man]fopen[/man], [man]preg_replace[/man] and [man]fwrite[/man]. What do you have for code so far?

rfigley

OK actually. This conversion is for a text file to be imported into an bulkd emailer program. I have the text file (comma and space delimited) that I want to replace the comma space with a carriage return. It not for a php application. I gues you'd say I wnat to convert it from ", " delimited to "Carriage return" or "next line" delimited without doing it manually. Like a search and replace. The problem is doing a search and replace using ASCII code.

TheDefender

Originally posted by TheDefender
Take a look at the following functions in the manual:
[man]fopen[/man], [man]preg_replace[/man] and [man]fwrite[/man]. What do you have for code so far?

And these functions in PHP will help you do just that. If you don't want to use PHP to do this, then you need to decide which language you want to use, and post your question on an applicable forum.

In PHP, use fopen to open the text file and get it's contents into a string. Use preg_replace to replace the commas with carriage returns, and use fwrite to write the converted string back to a text file.