Split n then concatenate files.

praveen.pinto · #1 (**permalink**) 02-15-2005

I have a file which has 350,000 records.
I want all of these in 1 excel sheet file(around 6 worksheets)
I used the below command to split it.

split -64000 Creditratingsdata.xls credits

Now i am having problems of appending into 1 excel file.
I even went to the extent of trying.

(cat (split -64000 Creditratingsdata.xls credits) >> why.xls)

so that the split file will be appended into why.xls........

ANY IDEAS ONTHE SAME LINES..............!!!!!!!!

thumsup9 · #2 (**permalink**) 02-15-2005

Quote:

Originally Posted by praveen.pinto

split -64000 Creditratingsdata.xls credits

ANY IDEAS ONTHE SAME LINES..............!!!!!!!!

What are the files split created .And if you are concatenating several files use '>' instead of '>>'

bhargav · #3 (**permalink**) 02-15-2005

what about ....

Code:

rm credits*              # not removing Creditratingsdata.xls
split -64000 Creditratingsdata.xls credits
cat credits* > x.xls

praveen.pinto · #4 (**permalink**) 02-16-2005

I tried the below given by u...

cp Creditratings.txt Creditratingsdata.xls
split -64000 Creditratingsdata.xls credits
cat credits* > x.xls

But it doesn add a new worksheet.
only one worksheet is created and
rows from 64001 get filled in that worksheet till 65536.
The remaining data is not loaded.

praveen.pinto · #5 (**permalink**) 02-16-2005

Hi thumsup 9.
the files created are......
creditsaa
creditsab
creditsac
creditsad

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to concatenate 2 files using awk?	pdtak	Shell Programming and Scripting	2	03-12-2008 01:12 PM
Script to concatenate several files	docaia	Shell Programming and Scripting	3	02-03-2008 09:07 AM
Concatenate text of two files in UNIX.	Uniq	UNIX for Advanced & Expert Users	1	01-19-2007 07:53 AM
Dvd files concatenate error: Not enough space	maag	SUN Solaris	3	05-06-2006 11:39 PM
How to concatenate all files.	s80bob	UNIX for Dummies Questions & Answers	1	08-22-2005 05:20 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by