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.