Post reply

Text Editor for Very Large Files

  • December 16, 2009 at 5:30 pm

    #385962

    Can anyone suggest a text editor for very large text files? I love Editplus and Notepad++, but they both give up on anything over 500Meg; I've got some data files that run as big a s a gig at a time, usually around 600meg;

    lately the export process is doinking the columns once in a while, so they fail on a bulk insert with a specific line number.

    so i need to edit the file at say, line 2,345,111 to fix it manually and rerun the bulk import.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 17, 2009 at 8:37 am

    #1093535

    I tend to use gvim for anything that won't open in notepad++. It's a gui version of a very popular linux editor that can run on Windows.

    The syntax can be baffling if you're not used to it, but going to a line number is pretty easy (just type :n with n being the line number). You can do all sorts of things with it once you've got used to the syntax: http://www.tuxfiles.org/linuxhelp/vimcheat.html

    I've definitely opened files of around 1GB before without problems.

  • December 17, 2009 at 9:58 am

    #1093585

    I use Textpad for opening large files and it works very well

    http://www.textpad.com/index.html

  • December 17, 2009 at 11:06 am

    #1093636

    UltraEdit. Haven't had a problem with it on any size file I've used it on. Very good, solid product.

  • December 18, 2009 at 10:24 am

    #1094164

    +1 for TextPad. I have been using it for at least 10 years. Awesome product.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • December 21, 2009 at 9:12 am

    #1094836

    KEDIT http://www.kedit.com/

    Can handle lots of data and is fast! Fully customizable interface (including line numbers) with built-in macro language KEXX (built on REXX http://en.wikipedia.org/wiki/Rexx)

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

  • December 21, 2009 at 9:22 am

    #1094852

    thanks for the input guys;

    for my first pass of fixes, i used gvim, but it's not the kind of utility i'm used to...i prefer text editors that open multiple files, familiar windows controls...that one seemed too close to UNIX for me to take a liking to.

    I've got an old version 10 of UltraEdit, and downloaded TextPad as well, and test drove both of them with todays exception file; they both do what i need, and a more familiar interface, with tabbed multiple documents and all the stuff i like.

    Thanks everyone

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 21, 2009 at 9:33 pm

    #1095240

    steveb. (12/17/2009)

    I use Textpad for opening large files and it works very well

    http://www.textpad.com/index.html

    I'll second that... Textpad and UltraEdit are both good in my book.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply