Re: Large loader file

[Quoted] On Mon, 8 Jul 2002 15:53:37 -0400, "bgt0990" <btighe_at_neometrics.com> wrote:

Try perl,
[Quoted]   perl -pi .bak -d 's/^ ^/^/g' yourfile.dat This is a standard task for perl.

Or just use NULLIF in your record definition.

-- 
Bill



>UltraEdit has a bug with the Carrets


>

>it will return ,^^^^,     or something similar, we did try it.

>

>

>"TurkBear" <jgreco1_at_mn.rr.com> wrote in message

>news:5gqjiu0924ue8slbcrri4e0mbnqbs32vgh_at_4ax.com...

>>

>> 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

>>

>> It has more features than any other programming editor I have ever used

>( with the possible exception of SPFPC)...

>>

>> 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

>=-----

>

>

>

>

>-----------== 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 =-----