Is there a way to handle commas inside the data when generating a csv file from shell script?
I am extracting data via sql query and some of the data has commas. Output File must be csv and I cannot update the data in the db (as it is used by other application).
Example
table FavoriteThings
Sample Data
excerpt from code
Output needs to be
currently I get
which when imported into excel shows 4 columns for Kurt
Last edited by vbe; 01-24-2019 at 02:39 PM..
Reason: code tags
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
TEST_HEME,"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1",CELL
when I split by
FS=","
then
$0=TEST_HEME
$1="SubNetwork=ONRM_RootMoR
$2=SubNetwork=ARNC1"
but I need this will be single value
"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1" (4 Replies)
Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.
Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?
The following sample data is saved as a .csv file in the... (2 Replies)
I need to read data from a file called "test.csv" through shell script where the file contains values like name,price,descriptor etc. There are rows where descriptor (& in some rows name) are written as string & other characters like "car_+" OR "bike*" etc where it should contains strings like... (3 Replies)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values.
Name, Address,... (7 Replies)
Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Hi List,
I have a chunk of data like so:
User Account Control:
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
... (3 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Discussion started by: mathias23
5 Replies
LEARN ABOUT MOJAVE
sub::install5.18
Sub::Install(3) User Contributed Perl Documentation Sub::Install(3)NAME
Sub::Install - install subroutines into packages easily
VERSION
version 0.927
SYNOPSIS
use Sub::Install;
Sub::Install::install_sub({
code => sub { ... },
into => $package,
as => $subname
});
DESCRIPTION
This module makes it easy to install subroutines into packages without the unsightly mess of "no strict" or typeglobs lying about where
just anyone can see them.
FUNCTIONS
install_sub
Sub::Install::install_sub({
code => &subroutine,
into => "Finance::Shady",
as => 'launder',
});
This routine installs a given code reference into a package as a normal subroutine. The above is equivalent to:
no strict 'refs';
*{"Finance::Shady" . '::' . "launder"} = &subroutine;
If "into" is not given, the sub is installed into the calling package.
If "code" is not a code reference, it is looked for as an existing sub in the package named in the "from" parameter. If "from" is not
given, it will look in the calling package.
If "as" is not given, and if "code" is a name, "as" will default to "code". If "as" is not given, but if "code" is a code ref,
Sub::Install will try to find the name of the given code ref and use that as "as".
That means that this code:
Sub::Install::install_sub({
code => 'twitch',
from => 'Person::InPain',
into => 'Person::Teenager',
as => 'dance',
});
is the same as:
package Person::Teenager;
Sub::Install::install_sub({
code => Person::InPain->can('twitch'),
as => 'dance',
});
reinstall_sub
This routine behaves exactly like "install_sub", but does not emit a warning if warnings are on and the destination is already defined.
install_installers
This routine is provided to allow Sub::Install compatibility with Sub::Installer. It installs "install_sub" and "reinstall_sub" methods
into the package named by its argument.
Sub::Install::install_installers('Code::Builder'); # just for us, please
Code::Builder->install_sub({ name => $code_ref });
Sub::Install::install_installers('UNIVERSAL'); # feeling lucky, punk?
Anything::At::All->install_sub({ name => $code_ref });
The installed installers are similar, but not identical, to those provided by Sub::Installer. They accept a single hash as an argument.
The key/value pairs are used as the "as" and "code" parameters to the "install_sub" routine detailed above. The package name on which the
method is called is used as the "into" parameter.
Unlike Sub::Installer's "install_sub" will not eval strings into code, but will look for named code in the calling package.
EXPORTS
Sub::Install exports "install_sub" and "reinstall_sub" only if they are requested.
exporter
Sub::Install has a never-exported subroutine called "exporter", which is used to implement its "import" routine. It takes a hashref of
named arguments, only one of which is currently recognize: "exports". This must be an arrayref of subroutines to offer for export.
This routine is mainly for Sub::Install's own consumption. Instead, consider Sub::Exporter.
SEE ALSO
Sub::Installer
This module is (obviously) a reaction to Damian Conway's Sub::Installer, which does the same thing, but does it by getting its greasy
fingers all over UNIVERSAL. I was really happy about the idea of making the installation of coderefs less ugly, but I couldn't bring
myself to replace the ugliness of typeglobs and loosened strictures with the ugliness of UNIVERSAL methods.
Sub::Exporter
This is a complete Exporter.pm replacement, built atop Sub::Install.
EXTRA CREDITS
Several of the tests are adapted from tests that shipped with Damian Conway's Sub-Installer distribution.
AUTHOR
Ricardo SIGNES <rjbs@cpan.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2005 by Ricardo SIGNES.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.18.2 2013-10-15 Sub::Install(3)