01-24-2019
I think in sqlplus there is a colsep setting.
set colsep |
to set to a | pipe character
you can then do a manual export into Excel, specifying the | as delimiter or
edit(replace) the , to ; and then the | to , --> and you would have a csv file with ; between elements
Otherwise, perhaps format your output inside you SELECT statement.
This User Gave Thanks to joeyg For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: Csmani
3 Replies
2. Shell Programming and Scripting
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)
Discussion started by: Hemendra
4 Replies
3. Shell Programming and Scripting
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)
Discussion started by: appu2176
2 Replies
4. Shell Programming and Scripting
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)
Discussion started by: raj100
3 Replies
5. Shell Programming and Scripting
Name,,,,,,,,,,,,,,,,,,,,Domain,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Contact,Phone,Email,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Location
-----------------------,------------------------------------------------,-------,-----,---------------------------------,------------------------------------
----... (1 Reply)
Discussion started by: sreenath1037
1 Replies
6. UNIX for Dummies Questions & Answers
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)
Discussion started by: Vivekit82
1 Replies
7. UNIX for Dummies Questions & Answers
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)
Discussion started by: Vivekit82
7 Replies
8. Shell Programming and Scripting
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)
Discussion started by: Vivekit82
14 Replies
9. Shell Programming and Scripting
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)
Discussion started by: landossa
3 Replies
10. Shell Programming and Scripting
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 DEBIAN
pymetrics
PYMETRICS(1) User Commands PYMETRICS(1)
NAME
pymetrics - Python source code metrics
SYNOPSIS
pymetrics [options] files...
DESCRIPTION
This manual page documents briefly the pymetrics command
pymetrics is a program that produces metrics for Python programs. Metrics include McCabe's Cyclomatic Complexity metric, LoC, %Comments,
etc. Users can also define their own metrics using data from PyMetrics. PyMetrics optionally outputs to stdout, SQL command files and CSV
files.
OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is
included below.
-h, --help
show this help message and exit
-s SQLFILENAME, --sql=SQLFILENAME
name of output SQL command file. (Default is metricData.sql)
-t SQLTOKENTABLENAME, --tokentable=SQLTOKENTABLENAME
name of output SQL token table. (Default is metricTokens)
-m SQLMETRICSTABLENAME, --metricstable=SQLMETRICSTABLENAME
name of output SQL metrics table. (Default is metricData)
-c CSVFILENAME, --csv=CSVFILENAME
name of output CSV data file. (Default is metricData.csv)
-f INFILELIST, --files=INFILELIST
File containing list of path names to modules for analysis.
-i INCLUDEMETRICSSTR, --include=INCLUDEMETRICSSTR
list of metrics to include in run. This is a comma separated list of metric module names with no whitespace. Optionally, you can
specify the class name of the metric by following the module name with a colon (:) and the metric class name. (Default metrics are
'simple:SimpleMetric,mccabe:McCabeMetric,sloc:SLOC Metric'. Default metric class name for metric module 'wxYz' is 'WxYzMetric' when
only module name given -- note capitalized metric class name.)
-l LIBNAME, --library=LIBNAME
user-defined name applied to collection of modules (Default is '')
-e, --exists
assume SQL tables exist and does not generate creation code. Using this option sets option -N. (Default is False)
-N, --noold
create new command output files and tables after deleting old results, if any. Ignored if -e is set. (Default is False)
-B, --nobasic
suppress production of Basic metrics (Default is False)
-S, --nosql
suppress production of output SQL command text file. (Default is False)
-C, --nocsv
suppress production of CSV output text file. (Default is False)
-H, --noheadings
suppress heading line in csv file. (Default is False)
-k, --kwcnt
generate keyword counts. (Default is False)
-K, --nokwcnt
suppress keyword counts. (Default is True)
-q, --quiet
suppress normal summary output to stdout. (Default is False)
-z, --zero
display zero or empty values in output to stdout. (Default is to suppress zero/empty output)
-v, --verbose
Produce verbose output - more -v's produce more output. (Default is no verbose output to stdout)
-d, --debug
Provide debug output, not usually generated - internal use only
AUTHOR
pymetrics was written by Reg. Charney.
This manual page was written by Andrew Pollock <apollock@debian.org>, for the Debian project (but may be used by others).
pymetrics 0.8.1 September 2009 PYMETRICS(1)