Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Split n then concatenate files.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Split n then concatenate files.
# 1  
Old 02-15-2005
Split n then concatenate files.
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..............!!!!!!!!
# 2  
Old 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 '>>'
# 3  
Old 02-15-2005
what about ....

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

# 4  
Old 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.
# 5  
Old 02-16-2005
Hi thumsup 9.
the files created are......
creditsaa
creditsab
creditsac
creditsad
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Split and Rename Split Files

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

2. UNIX for Dummies Questions & Answers

Concatenate files and delete source files. Also have to add a comment.

- Concatenate files and delete source files. Also have to add a comment. - I need to concatenate 3 files which have the same characters in the beginning and have to remove those files and add a comment and the end. Example: cat REJ_FILE_ABC.txt REJ_FILE_XYZ.txt REJ_FILE_PQR.txt >... (0 Replies)
Discussion started by: eskay
0 Replies

3. UNIX for Dummies Questions & Answers

Concatenate files

Hi I am trying to learn linux step by step an i am wondering can i use cat command for concatenate files but i want to place context of file1 to a specific position in file2 place of file 2 and not at the end as it dose on default? Thank you. (3 Replies)
Discussion started by: iliya24
3 Replies

4. UNIX for Dummies Questions & Answers

Concatenate Several Files to One

Hi All, Need your help. I will need to concatenate around 100 files but each end of the file I will need to insert my name DIRT1228 on each of the file and before the next file is added and arrived with just one file for all the 100files. Appreciate your time. Dirt (6 Replies)
Discussion started by: dirt1228
6 Replies

5. Shell Programming and Scripting

Concatenate files

I have a file named "file1" which has the following data 10000 20000 30000 And I have a file named "file2" which has the following data ABC DEF XYZ My output should be 10000ABC 20000DEF (3 Replies)
Discussion started by: bobby1015
3 Replies

6. Shell Programming and Scripting

How to concatenate text files together

Hi. I'm attempting to copy 4 text files together to create one larger file. All four files contain text in the same format. Can I do this? I attempted this, but it didn't work: cp wscreening_test_h_po.dat+wscreening_test_b_po.dat+wscreening_test_h_notpo.dat... (1 Reply)
Discussion started by: buechler66
1 Replies

7. Shell Programming and Scripting

Concatenate files

Hi, I want to create a batch(bash) file to combine 23 files together. These files have the same extension. I want the final file is save to a given folder. Once it is done it will delete the 23 files. Thanks for help. Need script. (6 Replies)
Discussion started by: zhshqzyc
6 Replies

8. Shell Programming and Scripting

Concatenate files

I have directory structure sales_only under which i have multiple directories for each dealer example: ../../../Sales_Only/xxx_Dealer ../../../Sales_Only/yyy_Dealer ../../../Sales_Only/zzz_Dealer Every day i have one file produce under each directory when the process runs. The requirement... (3 Replies)
Discussion started by: mohanmuthu
3 Replies

9. Shell Programming and Scripting

Concatenate columns from files

Hi, I have a file1.txt like this: and a file2.txt like this: I wat only append file2.txt to file1.txt and to have something like this: How could i do ? (2 Replies)
Discussion started by: AdminLew
2 Replies

10. UNIX for Dummies Questions & Answers

How to concatenate all files.

Hi, I'm totally new to Unix. I'm an MVS mainframer but ran into a situation where a Unix server I have available will help me. I want to be able to remotely connect to another server using FTP, login and MGET all files from it's root or home directory, logout, then login as a different user and do... (1 Reply)
Discussion started by: s80bob
1 Replies
Login or Register to Ask a Question