Hi Mark,
Actually my problem is upstream of that. I'm at the point where I'm converting a CSV
file so it can be dumped into a PostgreSQL table. PGAccess is looking for delimiters
(in my case ;)
and carrage returns at the end of each row. Unfortunately, the actual content of the
tables involves lots of carrage returns. What I need is a routine that can put them
out, either at
the MS Access end, or using a Linux text editor.
Best regards,
Frank Hilliard
Mark Woods wrote:
> 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.
