Replace(inputstring,chr(13)chr(10),'','ALL')
Should do it
HTH
_____
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: 07 June 2004 22:24
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]
