Summary report csv file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Summary report csv file
# 1  
Old 01-20-2013
Summary report csv file

Hello,

I have 2 csv files with 4 columns each.

file1.csv
A, AA, AAA, AAAA
B, BB, BBB, BBBB

file2.csv
C, CC, CCC, CCCC
D, DD, DDD, DDDD

I would like to use shell commands (sed, awk...) to copy the content of the 2 files (2x4 columns) into a final csv template file.

Expected result:
final.csv
A, AA, AAA, AAAA, C, CC, CCC, CCCC
B, BB, BBB, BBBB, D, DD, DDD, DDDD

Thank you guys for your help.
# 2  
Old 01-20-2013
Code:
paste -d"," file1.csv file2.csv

# 3  
Old 01-20-2013
Thank you bipinajith for your reply.
paste -d"," file1.csv file2.csv > final.csv will create a new output file.
In my template, I have some extra data I want to keep in the summary results.
So, I need to copy just the result of this command to my existent template file only in the first 8 columns change.
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Generate .csv/ xls file report

There can be thousand of .ksh in a specific directory where sql files are called from ksh. Requirement is to loop through all the files content and generate a report like below: Jobname Type type sqlname gemd1970 sql daily tran01 gemw1971 sql weekly ... (6 Replies)
Discussion started by: vedanta
6 Replies

2. Shell Programming and Scripting

Generate a Summary report

Hi All, Script to meet my requirement might be simpler for UINIX experts.. :) I need to generate an summary report in .txt file using shell script I have Reject directory in Unix server which contains all reject files for three diff categories- Presentation, Chapter and Scene Following... (3 Replies)
Discussion started by: Sakthikalluri
3 Replies

3. Shell Programming and Scripting

Parse diff output into very detailed & summary report

Hello all; I'll try an explain my dilemma as best I can. But first some background: 1- I am suppose to compare a database to itself before and after changes; basically generate audit trail report. 2- This database contains "RULES" (the id field) that we use for transmitting files. 3 - The... (0 Replies)
Discussion started by: gvolpini
0 Replies

4. UNIX for Dummies Questions & Answers

Creating a report from csv file.

Hi Gurus, I need your help in transforming the CSV file into some what a report format. My source file looks like below Date,ProdID,TimeID,LevelID 2010-08-31,200,M,1 2010-08-31,201,Q,2 2010-08-31,202,Y,1 2010-08-31,203,M,5 Output required is ... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies

5. Shell Programming and Scripting

CSV file report

Hi, I need to create a csv file using unix script on hourly manner. The report should be in format "Report_22_Sep_09_16IST.csv". Could you please suggest me. Thanks (1 Reply)
Discussion started by: Sekar1
1 Replies

6. Shell Programming and Scripting

how to add up a total in a summary report?

Hi all i got a script up but i cant add up the summary report.. keep having synax error . mind helping me to take a look and tell me what went wrong.. i know is a bit long but i hope someone can hep me with it. thanks the error message come up when i try to run the sumary report.. i guess... (16 Replies)
Discussion started by: xiaojesus
16 Replies
Login or Register to Ask a Question