At 08:21 AM 2/3/01 +0000, you wrote:
>Hi Mark,
Frank,
I think what Mark is saying is, after you upload your db to progres, run a
cfm script that strips all the carriage returns from each record. My
question is, are the carriage returns in the record before you convert to
progres or is the PGAccess program putting them in for some reason?
Brett
>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.
