The CR is ascii 13.  I use Replace(myvar, Chr(13), "", "ALL"). You may alsop
need to worry about line feeds which is character 10.


Tyler Clendenin
GSL Solutions

  _____  

From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Monday, June 07, 2004 5:24 PM
To: CF-Talk
Subject: Replacing special characters in a string

I have a set of strings that contain carriage returns.  I'd like to go
through and strip them out.  I figure the REPLACE function would do the
job but I'm not sure how to refer to the carriage returns.

INPUT STRING:

"I am a string with a
carriage return"

OUTPUT STRING:

"I am a string with a carriage return"

Any hints out there?

--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to