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.
6 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
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
3. UNIX for Dummies Questions & Answers
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
text::csv::encoded::coder::encodeguess
Text::CSV::Encoded::Coder::EncodeGuess(3pm) User Contributed Perl Documentation Text::CSV::Encoded::Coder::EncodeGuess(3pm)
NAME
Text::CSV::Encoded::Coder::EncodeGuess - Text::CSV::Encoded coder class using Encode::Guess
SYNOPSIS
use Text::CSV::Encoded coder_class => 'Text::CSV::Encoded::Coder::EncodeGuess';
use Spreadsheet::ParseExcel;
my $csv = Text::CSV::Encoded->new();
$csv->encoding( ['ucs2', 'ascii'] ); # guessing ucs2 or ascii?
$csv->encoding_to_combine('shiftjis');
my $excel = Spreadsheet::ParseExcel::Workbook->Parse( $file );
my $sheet = $excel->{Worksheet}->[0];
for my $row ( $sheet->{MinRow} .. $sheet->{MaxRow} ) {
my @fields;
for my $col ( $sheet->{MinCol} .. $sheet->{MaxCol} ) {
my $cell = $sheet->{Cells}[$row][$col];
push @fields, $cell->{Val};
}
$csv->combine( @fields ) or die;
print $csv->string, "
";
}
DESCRIPTION
This module is inherited from Text::CSV::Encoded::Coder::Encode.
USE
Except for 2 attributes, same as Text::CSV::Encoded::Coder::Encode.
encoding_in
$csv = $csv->encoding_in( $encoding_list_ref );
The accessor to an encoding for pre-parsing CSV strings. If no encoding is given, returns current $encoding, otherwise the object itself.
$encoding_list_ref = $csv->encoding_in()
When you pass a list reference, it might guess the encoding from the given list.
$csv->encoding_in( ['shiftjis', 'euc-jp', 'iso-20022-jp'] );
If it cannot guess the encoding, the first encoding of the list is used.
encoding
$csv = $csv->encoding( $encoding_list_ref );
$encoding_list_ref = $csv->encoding();
You can pass a list reference to this attribute only:
* For list data consumed by combine().
* For list reference returned by getline().
In other word, in "combine" and "print", it might guess an encoding for the passing list data. If it cannot guess the encoding, the first
encoding of the list is used.
SEE ALSO
Encode, Encode::Guess
AUTHOR
Makamaka Hannyaharamitu, <makamaka[at]cpan.org>
COPYRIGHT AND LICENSE
Copyright 2008-2010 by Makamaka Hannyaharamitu
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2010-04-26 Text::CSV::Encoded::Coder::EncodeGuess(3pm)