Sponsored Content
Top Forums Shell Programming and Scripting How to get sqlplus column header once in csv file? Post 302794877 by Yoda on Wednesday 17th of April 2013 01:25:01 AM
Old 04-17-2013
Set PAGESIZE option to higher number or set it to 0 if you want to suppress heading and page breaks.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How can I add a header to a csv file

I have a csv file which has no header. the file has 15 fields and needs to go out with a header of 8 fields. The header content needs to have some variables and some fixed that i have set up: variable header fields OUTFILE_YEAR=`date '+%y'` DATE=`date '+%d%m%y'` TIME=`date '+%H:%M:%S'`... (6 Replies)
Discussion started by: Pablo_beezo
6 Replies

2. Shell Programming and Scripting

Append Header in CSV file

Hi, I create a csv file and the output looks like below Arun,E001 Sathish,E003 Now i need to include the below header and the output should like below Name,Number Arun,E001 Sathish,E003 Please guide me. Thanks (4 Replies)
Discussion started by: Sekar1
4 Replies

3. Shell Programming and Scripting

Add header to a .csv file

Hi, I am trying to add a header record to all the .csv files in a directory. I am using the below sed commnad sed -i '1 i \abc,sam,xyz,tip,pep,rip' xyz.csv but this is not adding the header and I am not getting any error,pls tell me if any thing is wrong in the code. Thanks, Shruthi (2 Replies)
Discussion started by: shruthidwh
2 Replies

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

5. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

6. UNIX for Dummies Questions & Answers

Merge all csv files in one folder considering only 1 header row and ignoring header of all others

Friends, I need help with the following in UNIX. Merge all csv files in one folder considering only 1 header row and ignoring header of all other files. FYI - All files are in same format and contains same headers. Thank you (4 Replies)
Discussion started by: Shiny_Roy
4 Replies

7. UNIX for Dummies Questions & Answers

Creating a csv file with header in UNIX

I have a flat file that contains dynamic list of variables like a=1 b=2 c=3 . .. z=26 I need to convert the above into a csv file having the format below: a,b,c,..,z 1,2,3,..,26 Please note, I do not want a comma separating the last variable. I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies

8. Shell Programming and Scripting

Matching the header of a .CSV file with dynamic field names

I have a .CSV file (frequency - weekly) whose header contains the year-week value in two of the columns which keeps changing every week. For an instance please see below. Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9,Column10,Column11,Column12,Column13,201420... (4 Replies)
Discussion started by: dhruuv369
4 Replies

9. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

10. Shell Programming and Scripting

Script to validate header in a csv file

Hi All; I am struggling to write a script that validates file header. Header file would be like below with TAB separated TRX # TYPE REF # Source Piece Code Destination Piece Code every time I need to check the txt file if the header was same as above fields if validation success... (6 Replies)
Discussion started by: heye18
6 Replies
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)
All times are GMT -4. The time now is 01:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy