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
gtk2::sourceview2::printcompositor
Gtk2::SourceView2::PrintCompositor(3pm) User Contributed Perl Documentation Gtk2::SourceView2::PrintCompositor(3pm)NAME
Gtk2::SourceView2::PrintCompositor
HIERARCHY
Glib::Object
+----Gtk2::SourceView2::PrintCompositor
METHODS
printcompositor = Gtk2::SourceView2::PrintCompositor->new ($buffer)
o $buffer (Gtk2::SourceView2::Buffer)
printcompositor = Gtk2::SourceView2::PrintCompositor->new_from_view ($view)
o $view (Gtk2::SourceView2::View)
string = $compositor->get_body_font_name
$compositor->set_body_font_name ($font_name)
o $font_name (string)
double = $compositor->get_bottom_margin ($unit)
o $unit (Gtk2::Unit)
$compositor->set_bottom_margin ($margin, $unit)
o $margin (double)
o $unit (Gtk2::Unit)
buffer = $compositor->get_buffer
$compositor->draw_page ($context, $page_nr)
o $context (Gtk2::PrintContext)
o $page_nr (integer)
string = $compositor->get_footer_font_name
$compositor->set_footer_font_name ($font_name)
o $font_name (string or undef)
$compositor->set_footer_format ($separator, $left, $center, $right)
o $separator (boolean)
o $left (string or undef)
o $center (string or undef)
o $right (string or undef)
string = $compositor->get_header_font_name
$compositor->set_header_font_name ($font_name)
o $font_name (string or undef)
$compositor->set_header_format ($separator, $left, $center, $right)
o $separator (boolean)
o $left (string or undef)
o $center (string or undef)
o $right (string or undef)
boolean = $compositor->get_highlight_syntax
$compositor->set_highlight_syntax ($highlight)
o $highlight (boolean)
double = $compositor->get_left_margin ($unit)
o $unit (Gtk2::Unit)
$compositor->set_left_margin ($margin, $unit)
o $margin (double)
o $unit (Gtk2::Unit)
string = $compositor->get_line_numbers_font_name
$compositor->set_line_numbers_font_name ($font_name)
o $font_name (string or undef)
integer = $compositor->get_n_pages
boolean = $compositor->paginate ($context)
o $context (Gtk2::PrintContext)
double = $compositor->get_pagination_progress
boolean = $compositor->get_print_footer
$compositor->set_print_footer ($print)
o $print (boolean)
boolean = $compositor->get_print_header
$compositor->set_print_header ($print)
o $print (boolean)
integer = $compositor->get_print_line_numbers
$compositor->set_print_line_numbers ($interval)
o $interval (integer)
double = $compositor->get_right_margin ($unit)
o $unit (Gtk2::Unit)
$compositor->set_right_margin ($margin, $unit)
o $margin (double)
o $unit (Gtk2::Unit)
integer = $compositor->get_tab_width
$compositor->set_tab_width ($width)
o $width (integer)
double = $compositor->get_top_margin ($unit)
o $unit (Gtk2::Unit)
$compositor->set_top_margin ($margin, $unit)
o $margin (double)
o $unit (Gtk2::Unit)
wrapmode = $compositor->get_wrap_mode
$compositor->set_wrap_mode ($wrap_mode)
o $wrap_mode (Gtk2::WrapMode)
PROPERTIES
'body-font-name' (string : default undef : readable / writable)
Name of the font to use for the text body (e.g. "Monospace 10")
'buffer' (Gtk2::SourceView2::Buffer : default undef : readable / writable / construct-only)
The GtkSourceBuffer object to print
'footer-font-name' (string : default undef : readable / writable)
Name of the font to use for the page footer (e.g. "Monospace 10")
'header-font-name' (string : default undef : readable / writable)
Name of the font to use for the page header (e.g. "Monospace 10")
'highlight-syntax' (boolean : default true : readable / writable)
Whether to print the document with highlighted syntax
'line-numbers-font-name' (string : default undef : readable / writable)
Name of the font to use for the line numbers (e.g. "Monospace 10")
'n-pages' (integer : default -1 : readable)
The number of pages in the document (-1 means the document has not been completely paginated).
'print-footer' (boolean : default false : readable / writable)
Whether to print a footer in each page
'print-header' (boolean : default false : readable / writable)
Whether to print a header in each page
'print-line-numbers' (Glib::UInt : default 1 : readable / writable)
Interval of printed line numbers (0 means no numbers)
'tab-width' (Glib::UInt : default 8 : readable / writable)
Width of a tab character expressed in spaces
'wrap-mode' (Gtk2::WrapMode : default "none" : readable / writable)
Whether to wrap lines never, at word boundaries, or at character boundaries.
ENUMS AND FLAGS
enum Gtk2::Unit
o 'pixel' / 'GTK_UNIT_PIXEL'
o 'points' / 'GTK_UNIT_POINTS'
o 'inch' / 'GTK_UNIT_INCH'
o 'mm' / 'GTK_UNIT_MM'
enum Gtk2::WrapMode
o 'none' / 'GTK_WRAP_NONE'
o 'char' / 'GTK_WRAP_CHAR'
o 'word' / 'GTK_WRAP_WORD'
o 'word-char' / 'GTK_WRAP_WORD_CHAR'
SEE ALSO
Gtk2::SourceView2, Glib::Object
COPYRIGHT
Copyright (C) 2009 by Emmanuel Rodriguez
perl v5.14.2 2011-11-16 Gtk2::SourceView2::PrintCompositor(3pm)