Solved

How to add carriage return with find and replace

Posted on 2003-11-19
4
365 Views
Last Modified: 2010-04-06
Hi, I don't know where I should be posting this, but I hope this forum can answer my question.
I have a mailing list with about 2000 emails that are separated by commas. The program I'm using seems to require each email be on a separate line. So instead of:

email@email.com, email2@email.com

I want:

email@email.com,
email2@email.com

So I just want to do a find and replace on "," and replace it with ", carriage return".

The text editor also supports regular expressions. Thanks.

0
Comment
Question by:Quarfelburg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 35

Expert Comment

by:YZlat
ID: 9782263
carriage return is vbCrLf  as well as chr(13)
0
 
LVL 35

Accepted Solution

by:
YZlat earned 100 total points
ID: 9782283
Replace(myString, ",", VbCrLf )
0
 
LVL 2

Expert Comment

by:Mikehd
ID: 9782302

Carriage return is also  \r

for html and javascript regualar expressions

M=
0
 
LVL 35

Expert Comment

by:YZlat
ID: 9782359
or use "\n"

strTest=Replace(myString, ",", "\n")
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to run file 9 130
ColdFusion Rereplace 3 87
Problem to file 3 92
Grunt No Clean Targets 6 230
There are two main kinds of selectors in CSS: One is base selector like h1, h2, body, table or any existing HTML tags.  For instance, the following rule sets all paragraphs (<p> elements) to red: (CODE) CSS also allows us to define our own custom …
Shoutout to Emily Plummer (http://www.experts-exchange.com/members/eplummer26.html) for giving me this article! She did most of it, I just finished it up and posted it for her :)    Introduction In a previous article (http://www.experts-exchang…
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question