Regular expressions...
(get more info in the CF4.0 documentation, advanced book. You can find these
docs on the allaire site - the CF 4.5 docs are missing a lot of detail).
CF has built in string functions which can use regular expressions, so you can
for example search for any sequence of more than one CR and replace the
sequence with just one CR. (though, they are probably CRLF sequences if you're
dealing with a file created on windows)
AFAIK, the syntax to replace multiple CRLF sequences with one is...
REreplace(string,"(#Chr(13)##Chr(10)#)+","#Chr(13)##Chr(10)#","ALL")
(#Chr(13)##Chr(10)#)+ matches one or more instances of the #Chr(13)##Chr(10)#
sequence and these matches are replace with just one #Chr(13)##Chr(10)#
sequence.
Mark
At 04:28 PM 2/2/01 +0000, you wrote:
>I'm converting Access tables to postgres tables using PGAccess. I've done
three smaller ones, but I've got one here now that has a lot of content with
more than 3,000 carrage returns.
>How can I get rid of them, either on the Dos side or on the Linux side?
(Aside
from just deleting the little mothers manually) =:(
>
>Frank Hilliard
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
