Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Jul 2003
    Location
    Geneva, Switz.
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What app - 300 Mb txt file?

    I bought a 68,000+ Articles database off this guy, but it came as a 300 Mb text files, which is too large to upload to my databse, and too big to open in any text editor to split into managable chunks.

    It has already crashed Notepad and Wordpad...

    Does anyone know what app would be robust enough to let me open this and copy/paste chunks into smaller txt files?
    Thanks,

    Neil

  • #2
    Senior Coder
    Join Date
    Oct 2005
    Posts
    1,340
    Thanks
    0
    Thanked 61 Times in 60 Posts
    Yes, notepad and wordpad won't handle that. I assume you don't have MS Word/Office so use OpenOffice from openoffice.org. Great open source free app.

    Now, I haven't yet found whether Office or OpenOffice can handle a 300Mb file but I assume they can.

  • #3
    Regular Coder
    Join Date
    Sep 2005
    Location
    Madison, Indiana, USA
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts
    vi or vim will easily handle a that size.

  • #4
    Senior Coder
    Join Date
    Feb 2003
    Location
    Ontario, Canada
    Posts
    1,223
    Thanks
    0
    Thanked 0 Times in 0 Posts
    As would UltraEdit, I believe. www.ultraedit.com

    He sent a database as .txt files? Or are they .sql files? If so, you should be able to feed them to your database server directly and have it build the database for you. You're still going to end up with a large database though, as tens of thousands of full articles aren't going to be small :P

  • #5
    New Coder
    Join Date
    Jul 2003
    Location
    Geneva, Switz.
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by drhowarddrfine
    I assume you don't have MS Word/Office so use OpenOffice from openoffice.org. Great open source free app.
    Yes, I do have the Office suite, I hadn't thought of that, it opened fine in Word, and I was able to split it into several smaller files for importing. Thanks!

    However, now it seems I have an even bigger problem...

    Half the single-quotes in the database are un-escaped, meaning that when I try to import the .sql file, phpMyAdmin thinks that the SQL INSERT statements end prematurely, and throws up errors! Is there any way to escape the quotes within the columns, whilst leaving the necessary quotes that delimited the columns themselves?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •