Ahh, darnit, I used Replace before, using Chr(10) and Chr(13) but forgot
about the scope portion of Replace....guess I thought it was optional.....
thanks for the help everyone.
--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.
> -----Original Message-----
> From: Jamie Keane [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 09, 2001 9:36 AM
> To: CF-Talk
> Subject: Re: Stripping CRs and LFs
>
>
> 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
