Re: Large loader file

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Mon, 08 Jul 2002 14:41:05 -0500
Message-ID: <5gqjiu0924ue8slbcrri4e0mbnqbs32vgh_at_4ax.com>


[Quoted] [Quoted] Daniel's solution is the preferred path, but, to get an editor for use with BIG files ( only in a Windows version so far) try UltraEdit32 -
http://www.ultraedit.com

[Quoted] [Quoted] It has more features than any other programming editor I have ever used ( with the possible exception of SPFPC)...

[Quoted] It can handle files up to 2Gb for editing ...

"bgt0990" <btighe_at_neometrics.com> wrote:

>I have a 280MB loader file that was produced with Foxpro, in the file every
>instance of what should be a NULL was converted by Foxpro to a space. So I
>have the sequence ,^space^, when it should be ,^^,
>
>I don't have access to Foxpro to see if this can be fixed there. The file
>is way to big for any editor we have tried to do a search and replace with,
>even if the editor will handle the file size they can't handle a search and
>replace that big. (even my trusty Vi choked).
>
>
>Is there an easy way to fix this with SQL_loader or a way to do this in SQL
>against the entire schema of 60 some odd tables??
>
>Any help would be appreciated
>Barry
>
>
>
>
>-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
>-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Mon Jul 08 2002 - 21:41:05 CEST

Original text of this message