<cfset Commentary = replace(Commentary,"|. ","|. #chr(13)##chr(10)#","ALL")>
Not sure about needing the # signs....but you don't need the &s that you had
HTH
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Parker, Kevin
To: CF-Talk
Sent: Wednesday, March 24, 2004 5:46 PM
Subject: replace
It may be the way I'm applying this.
I'm just making a tweak to a love job I did for The Salvos. One of the
databases we converted for this did not bring over the CR's and LF's between
paragraphs in one of the fields. Rather than getting someone to edit every
record I'm trying to deal with this programmatically.
I have identified the place to insert the CR LF as bits like this "#2Th
3:10|. " regularly appear through the text, albeit the numbers are
different, but the "|. " is a reliable indicator of where the paragraph
break should be, however, the app does not want to recognise the CR and LF.
Its not clear to me if replace will insert ASCII characters or not.
<cfset Commentary = replace(Commentary,"|. ","|. & chr(13) & chr(10)",
"ALL")>
TIA!!!
+++++++++++++++++++
Kevin Parker
Web Services Manager
WorkCover Corporation
p: 08 8233 2548
e: [EMAIL PROTECTED]
w: www.workcover.com
+++++++++++++++++++
************************************************************************
This e-mail is intended for the use of the addressee only. It may
contain information that is protected by legislated confidentiality
and/or is legally privileged. If you are not the intended recipient you
are prohibited from disseminating, distributing or copying this e-mail.
Any opinion expressed in this e-mail may not necessarily be that of the
WorkCover Corporation of South Australia. Although precautions have
been taken, the sender cannot warrant that this e-mail or any files
transmitted with it are free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any
copies.
************************************************************************
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
