Frank,
I've done things just like this on a fairly massive scale using Search
and Replace from Funduc Software. It's a really great program, it's
like having the power of Unix command line text processing tools in a
Windows GUI. You can script together series of commands, so in you case
you might do something like (1) determine the fewest number of returns
at the end of any of your records, for example 15 (or just approximate),
and then (2) script to repeatedly remove one less than that number of
CRs, down to the number you want, e.g., 14, 13, 12, etc., down to 2 CRs,
then (3) replace all instances of 2 CRs with your desired character,
such as ;. If you're interested, I might be able to find an example SR
script, which you could bring into your own copy of SR to modify/run.
-- Peter Yellman
Frank Hilliard 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.
