Re: Large loader file
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