11-29-2007
This link shows how to split/recombine any file, into whatever size you want:
fsplit -- splitting up a binary file
However, an excel file would need to be recombined to work correctly, as its formatted in such a way, i.e, a binary file.you can't just cut it up and use the pieces.
I've used this to split >2G binary files, to put on fileservers that are not largefile aware, then they get copied to thier destination, recombined, and
everything works just fine.
The real fix for your delima will be in changing the program thats creating your "to large" excel file, to having a limit of ( 64k - some safety factor ), and putting the remainder into another file. Programs/scripts that create any sort of data, files, etc really need to be aware of the limitation of whatever will be using output it creates.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have a large file with the first 2 characters of each line determining the type of record. type 03 being a subheader and then it will have multiple 04 records.
eg: 03,xxx,xxxx,xxxx
04,xxxxxxxxxxxxxxxxxxxxxxxxxxxx
04,xxxxxxxxxxxxxxxxxxxxxxxxxxxx
03,xxx,xxx,xxx
... (2 Replies)
Discussion started by: badg3r
2 Replies
2. UNIX for Dummies Questions & Answers
I have gone through all the threads in the forum and tested out different things. I am trying to split a 3GB file into multiple files. Some files are even larger than this.
For example:
split -l 3000000 filename.txt
This is very slow and it splits the file with 3 million records in each... (10 Replies)
Discussion started by: madhunk
10 Replies
3. Shell Programming and Scripting
Hi All,
I have a strange behaviour from csplit command on some text files.
I have a comma separated file and data with in double quotes. This file is being generated from Sequential stage of Data stage tool.
This file has 67 fields in each records with some null and blank in the data.... (4 Replies)
Discussion started by: shreekrishnagd
4 Replies
4. UNIX for Dummies Questions & Answers
Hi,
This is my first time on this forum..
I searched the previous answers, but didn't find the answer I was looking for at first glance.
csplit works beautifully for me, except for one thing. My file looks like this:
ad|name1|asdf...(several pages)..asdf ...
ad|name2|asdf...(several... (8 Replies)
Discussion started by: juliette salexa
8 Replies
5. Shell Programming and Scripting
Hello all
The below command works perfeft when executed from the shell prompt.
"csplit -f first Allocation.log.1 "%. Oct 02 .%" {1} "
and generates first00 file.
But it fails if I include the same command in my script.
I am trying to automate some process and this is turning... (1 Reply)
Discussion started by: uandme2k2
1 Replies
6. Shell Programming and Scripting
I have a file with contents
<wmqi>
sdf
sdf
sdffghghhjjfh
</wmqi>
<wmqi>
gh
dfg
hhjhj
sdfsdf
g
</wmqi>
<wmqi>
dfgdf
fg
dfgfg
</wmqi>
<wmqi> (6 Replies)
Discussion started by: Shivdatta
6 Replies
7. UNIX for Dummies Questions & Answers
I want to split big files based on a pattern to stdout.
Although csplit works well for me splitting the output into separate files (e.g. xx00, xx01, xx02, ...), the following is not working as expected:
<code>
# assuming pattern occurs less than 100 times
csplit bigfile '%pattern%'... (2 Replies)
Discussion started by: uiop44
2 Replies
8. Shell Programming and Scripting
Hello,
I want to split a big file into smaller ones with certain "counts". I am aware this type of job has been asked quite often, but I posted again when I came to csplit, which may be simpler to solve the problem.
Input file (fasta format):
>seq1
agtcagtc
agtcagtc
ag
>seq2
agtcagtcagtc... (8 Replies)
Discussion started by: yifangt
8 Replies
9. UNIX for Beginners Questions & Answers
Hello,
I need to split a file by number of records and rename each split file with actual filename pre-pended with 3 digit split number.
What I have tried is the below command with 2 digit numeric value
split -l 3 -d abc.txt F (# Will Produce split Files as F00 F01 F02)
How to produce... (19 Replies)
Discussion started by: techedipro
19 Replies
10. UNIX for Beginners Questions & Answers
i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)
Discussion started by: malaika
2 Replies
FSPLIT(1) General Commands Manual FSPLIT(1)
NAME
fsplit - split a multi-routine Fortran file into individual files
SYNOPSIS
fsplit [ -e efile] ... [ file ]
DESCRIPTION
Fsplit takes as input either a file or standard input containing Fortran source code. It attempts to split the input into separate routine
files of the form name.f, where name is the name of the program unit (e.g. function, subroutine, block data or program). The name for
unnamed block data subprograms has the form blkdtaNNN.f where NNN is three digits and a file of this name does not already exist. For
unnamed main programs the name has the form mainNNN.f. If there is an error in classifying a program unit, or if name.f already exists,
the program unit will be put in a file of the form zzzNNN.f where zzzNNN.f does not already exist.
Normally each subprogram unit is split into a separate file. When the -e option is used, only the specified subprogram units are split
into separate files. E.g.:
fsplit -e readit -e doit prog.f
will split readit and doit into separate files.
DIAGNOSTICS
If names specified via the -e option are not found, a diagnostic is written to standard error.
AUTHOR
Asa Romberger and Jerry Berkman
BUGS
Fsplit assumes the subprogram name is on the first noncomment line of the subprogram unit. Nonstandard source formats may confuse fsplit.
It is hard to use -e for unnamed main programs and block data subprograms since you must predict the created file name.
4.2 Berkeley Distribution April 29, 1985 FSPLIT(1)