I have a 1.5GB Text file I need to split in half....suggestions? Not even 1/2 but into smaller usable pieces.
When I import into a DB, I max out my 2GB limit.

 

Do you have a problem compressing it?
WinRAR can compress it into split files of whatever size you want.

(Eg. myfile.txt 4MB in size compresses to
myfile.r00
myfile.r01
myfile.r02
myfile.r04
with each one having a 1MB file size, or whatever other size you choose)

You just open up the .r00 file and extract like you would with any .zip file, it does the rest and puts it all back together for you.

Edit:
Looks like thats not what you want... Just open the text file and cut/paste parts into a new file I guess.

 

is it random text or some pattern (ie line returns, comma deliminated, etc)

 

I need to import this into a database and use the data before business starts tomorrow. It's not an issue of compressing the file; its a matter of getting it into Foxpro without exceeding 2GB file size limits.

Phone number, useless data 5 digit
Phone number, useless data 5 digit
Phone number, useless data 5 digit
Phone number, useless data 5 digit
Phone number, useless data 5 digit
Phone number, useless data 5 digit

 

I'm going to assume you dont have access to a SQL server.

You should be able to find plenty of free programs that will split files for you.

Google search of "split text files" found plenty.

I have always dumped it to SQL server and gone from there.

Assuming that isnt an option these programs can split based on X number of lines, etc.

 

there is tons of software to do it.

http://www.google.com/search?hl=en&q...files+splitter

If you have access to a linux box you could use split.

split [-linecount | -l linecount ] [ -a suffixlength ] [file [name] ]

 

Yea; I'm downding mySQL but hopefully I wont need it.

Trying one of those programs now; I wasnt sure if they would handle a file of this size......

Looks like it worked; Whew; that's a start. It took me all day to import this into Foxpro just to find out I hit 1.99GB. DOH. Time to start over with my new pieces.

UC Out

 

If you come back in...

http://www.jaojsoft.com/divij15e.exe

Is one that is free...

 

What are you doing with 2 GB text files?

I had that problem with our web server log files. They got to be 1.5GB a day.

Good luck. One of those pieces of software should work. They are pretty simple to use.

 

The FTC gave it to me.

 

2GB text file?

What is that.....like every encyclopedia ever printed, plus all the Bibles and phone books all in one file?

Wow.

 

UC is a telemarketer......

 

Please tell me this is a formated text of some kind and not just a .txt file....

 

It was actually "areacode, telephone" flat .txt file

I'm still working with the data and it is 10pm here. Although I did forget about it completely between 5pm and 9pm. I think I'll be data processing for another hour.

I dont know what Bill is talking about

 

Make sure my number isn't on that dang thing.