Couldn't you replace all instances of Chr(13) (I think that's right...) with
a null?
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.849.7771 x 228 Voice
704.849.9291 Fax
-----Original Message-----
From: Bryan Batchelder <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Tuesday, January 09, 2001 9:13 AM
Subject: Stripping CRs and LFs
>What is the best way to strip CRs and LFs from a string?
>
>StripCR() gets the CRs....but I still have linefeeds (or CR/LF combos...)
>left in the string.
>
>I am doing this as part of cleaning up data from an SQL server to put into
a
>..CSV file...and well, CSV doesn't handle random CR/LF very well :-)
>
>Thanks in advance...
>
>--b
>
>--------------------------------------------------
>Bryan Batchelder Home:727.547.1322
>Web Application Developer Work:813.935.7100 x427
> Cell:727.460.6665
>--------------------------------------------------
> Company:http://www.connectwise.com
>Personal:http://pontiphex.stetsonsucks.com
> PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt
>--------------------------------------------------
>At the macro level, it may appear that I am doing
>nothing. But at the cellular level I am really
>quite busy.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
