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