Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Splitting large txt report files

    • Article Type: General
    • Product: SFX
    • Product Version: 3

    Description:
    Some of our report files are too large to be opened and viewed in Excel. What should we do to view the files?

    Resolution:
    To view the files, split them in the directory whether txt reports are located,
    then download split files for view.

    go to:

    /exlibris/sfx_ver/sfx_version_3/tmp/kbdb-reports/<instancename >
    and the subdirectory for the update months of your choice.

    then execute the command with the following syntax:

    split [Input file name] --lines=[Number of lines] [output file name]

    (example):
    split OBJECT_PORTFOLIO-changed.txt --lines=50000 OBJECT_PORTFOLIO-changed

    split files will be created with suffixes in alphabetical order - the first part will have suffix aa, the second suffix ab, etc.

    In the example above, files with the names:
    OBJECT_PORTFOLIO-changedaa
    OBJECT_PORTFOLIO-changedab
    OBJECT_PORTFOLIO-changedac

    will be created in the same directory.

    Additional Information

    split,reports,txt,Excel,directory,update


    • Article last edited: 10/8/2013
    • Was this article helpful?