We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Reformat Function

thenone
thenone asked
on
Medium Priority
280 Views
Last Modified: 2010-05-01
I need a function that will reformat text like example that will remove all double spaces and carriage returns.

example text.



 Editors Weblog Print
 Journalism
 
 Order Newsletter
 
Recent Posts
============
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 
 
 
 
 
 
Links
=====
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 Â·
 
 
 
Thursday, January 5, 2006
=========================
 
Newspapers are wireless
 
 
An interesting article from Fred Grimm of the _Miami Herald_ that humorously turns ideas
about new technology and the media on their head. He begins by pointing out the obvious,
that newspapers require no cords or telephone connections and are wireless: "We were
wireless long before wireless was cool."
 
He moves on to highlight the newspaper's "paper thin technology each page 40 times skinnier
than an i Pod Nano", its easy transportability; you can take it anywhere and you won't be
asked to switch it off, and its dependability; "Your newspaper may be the only communication
device in the high tech age that operates with candlelight."
 
Other advantages that the newspaper has over new technologies include: the fact that your
paper "comes without risk that a virus will invade your computer", and the absence of
"Annoying ads."
 
Grimm confesses that the reason for his musings is the pending sale of the Herald's owner
Knight Ridder (see previous postings here and here), "I bring all this up only because I
hear we're for sale. Something about a rebellion among institutional investors upset with
Knight Ridder's stock performance." Essentially, the problem, as Grimm states it, is that
newspapers, in the eyes of much of the business world, "are yesterday's beer."
 
He concludes by saying that the newspaper's best quality is that no batteries are necessary.
 
 
Source:  
 
Posted by Dominique Lewis Tuohy on January 5, 2006 at 04:34 PM
 
Post a comment
 
 
Remember personal info?
 
TrackBack
 
 
TrackBack URL for this entry:
http://193.218.105.89:8081/mt tb.cgi/16719
 
Listed below are links to weblogs that reference :
Please send technical comments regarding this site to our .
© 2004 . All rights reserved. .
 
 
Editor's choice
===============
 
·
 
·
 
·
 
·
 
·
 
Recent Posts
Print Journalism
==================================
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
·
 
 
Comment
Watch Question

Retired
CERTIFIED EXPERT
Top Expert 2012
Commented:
Your context isn't specified but to replace all double spaces with a single space:

Do While Instr(MyString, "  ")  > 0
     Replace MyString, "  ", " "
Loop

To remove all carriage returns
 
Replace MyString, vbcr, ""



Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.