Hi,
I am getting the data from text file and it contains comma and double quootes.
Eg: text file like this:
I want to read this data and generate the .csv file.
each row of the file has to accomidate in a column of csv file. since this data contains comma, if i take as it is it is splitting into mutliple columns which is not correct. Hence i am using the below command before and after :
But still there double quotes in my data, it is splitting into multiple columns. Please provide me the solution for this.
Regards,
Rajesh
Moderator's Comments:
Please use [code] and [/code] tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks.
Last edited by zaxxon; 05-10-2011 at 09:14 AM..
Reason: code tags
I have various column names within double quotes, separated by commas.
Example:
"column one", "column number two", "this is column number three", anothercolumn, yetanothercolumn
I need to eliminate the double quotes and replace the blanks within the double quotes by underscores, giving:
... (5 Replies)
Hi,
I have a requirement to replace the comma's inside the double quotes. The comma's inside the double quotes will get changed dynamically.
Input Record:
"Washington, DC,Prabhu,aju",New York
Output Record:
"Washington| DC|Prabhu|aju",New York
I tried with the below command but it... (3 Replies)
Hi,
I have data as
"01/22/97-"aaaaaaaaaaaaaaaaa""aaa""aabbbbbbbbcccccc""zbcd""dddddddddeeeeeeeeefffffff"
I want to remove only the Consequitive double quotes and not the one which occurs single.
My O/P must be ... (2 Replies)
In bash or perl, I would like to know how to substitute a null character (0x00) for every white space without changing the white spaces inside the block of double quotes and the white space immediately following a backslash.
Suppose that sample.txt consists of the following line.
"b 1" c\ 2
... (2 Replies)
Hi Guys,
I have a file with content as below
aj.txt
"Iam
allfine" abcdef
abcd "all is
not well"
What I'm trying to say is my data has some new line characters in between quoted text. I must get ride of the newline character that comes in between the quoted text.
output must be:... (8 Replies)
Hi Froum.
I have tried in vain to find a solution for this problem - I'm trying to replace any double quotes within a quoted string with a single quote, leaving everything else as is.
I have the following data:
Before:
... (32 Replies)
Hello,
Need a AWK command to find and replace Double Quotes in Pipe delimited files
Actully its a CSV file converted to Pipe but the double quotes still exists. So i want to Get rid of them.
Example
Input
1|2|3|sadsad|"Abc Efg 3"""|dada
Output
1|2|3|sadsad|Abc Efg 3"|dada
Thanks... (5 Replies)
Hi All,
I have been trying to replace a string using the sed command
string value contain blackslash and double quotes. I am not a expert writer of unix script but do try not to ask question. I have almost given up. Hope you all can give me some suggestion
I want to replace a place string... (6 Replies)
Hi All,
I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes.
Sample Data :
"221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
I need to replace consecutive double quotes in a csv file, the data in the file is enclosed in double quotes but there are some places where the quotes are repeating
Example is below
Incoming data is :
"Pacific Region"|"PNG"|"Jimmy""|""|
Need output as:
"Pacific... (10 Replies)
Discussion started by: abhilashnair
10 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)