Shell Programming and Scripting

# File_1.sql - Using COLSEP
SET LINESIZE 700 -- This may change, depends on your output line size
SET PAGESIZE 0
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET COLSEP ","
-- Example query
Select 1,
         2
From Dual;

# File_2.sql - Using "CONCAT"
SET LINESIZE 700 -- This may change, depends on your output line size
SET PAGESIZE 0
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
-- Example query
Select 1 || ',' ||
         2
From Dual;

REPLACE(TABLE_COLUMN, ',', ' ')

#!/usr/bin/perl -w
###############################################################################
#
# Example of how to use the WriteExcel module
#
# Program to convert a CSV comma-separated value file into an Excel file.
# This is more or less an non-op since Excel can read CSV files.
# The program uses Text::CSV_XS to parse the CSV.
#
# Usage: csv2xls.pl file.csv newfile.xls
#
# reverse(''), March 2001, John McNamara, jmcnamara@cpan.org
#
use strict;
use Spreadsheet::WriteExcel;
use Text::CSV_XS;
# Check for valid number of arguments
if (($#ARGV < 1) || ($#ARGV > 2)) {
   die("Usage: csv2xls csvfile.txt newfile.xls\n");
};
# Open the Comma Separated Variable file
open (CSVFILE, $ARGV[0]) or die "$ARGV[0]: $!";
# Create a new Excel workbook
my $workbook  = Spreadsheet::WriteExcel->new($ARGV[1]);
my $worksheet = $workbook->add_worksheet();
# Create a new CSV parsing object
#my $csv = Text::CSV_XS->new;
#binmode CSV;
#my $csv = Text::CSV_XS->new({
my $csv = Text::CSV_XS->new({
        'quote_char'  => '"',
        'escape_char' => '',
        'sep_char'    => '|',
        'binary'      => 1,
});

# Row and column are zero indexed
my $row = 0;

while (<CSVFILE>) {
    if ($csv->parse($_)) {
        my @Fld = $csv->fields;
        my $col = 0;
        foreach my $token (@Fld) {
            $worksheet->write($row, $col, $token);
            $col++;
        }
        $row++;
    }
    else {
        my $err = $csv->error_input;
        print "Text::CSV_XS parse() failed on argument: ", $err, "\n";
    }
}