The requirement regarding leaving double quotes around a field if there is no space is the difficult part. Try the following and please report back on how it worked out. I am sure there is a more efficient way of doing the work but this should work for you.
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
Need to run below command on remote server:
cmd -a "1 2" -b 3
If i run below, there's clash matching double quotes and fail.
ssh $server "cmd -a "1 2" -b 3"
I have few ideas which worked (like keeping the entire cmd in a file and copy it to remote server and then run that file)... (1 Reply)
Hi,
I am getting the data from text file and it contains comma and double quootes.
Eg: text file like this:
Travelling up Cattai Ridge Rd, going through the "S" bends at the top.
Felt a "pull" and pain in groin area, on right side after lifting at work.
Repeat "twisting" while working manual... (4 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'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 REDHAT
encode::alias
Encode::Alias(3pm) Perl Programmers Reference Guide Encode::Alias(3pm)NAME
Encode::Alias - alias definitions to encodings
SYNOPSIS
use Encode;
use Encode::Alias;
define_alias( newName => ENCODING);
DESCRIPTION
Allows newName to be used as an alias for ENCODING. ENCODING may be either the name of an encoding or an encoding object (as described in
Encode).
Currently newName can be specified in the following ways:
As a simple string.
As a qr// compiled regular expression, e.g.:
define_alias( qr/^iso8859-(d+)$/i => '"iso-8859-$1"' );
In this case, if ENCODING is not a reference, it is "eval"-ed in order to allow $1 etc. to be substituted. The example is one way to
alias names as used in X11 fonts to the MIME names for the iso-8859-* family. Note the double quotes inside the single quotes.
If you are using a regex here, you have to use the quotes as shown or it won't work. Also note that regex handling is tricky even for
the experienced. Use it with caution.
As a code reference, e.g.:
define_alias( sub { return /^iso8859-(d+)$/i ? "iso-8859-$1" : undef } , '');
In this case, $_ will be set to the name that is being looked up and ENCODING is passed to the sub as its first argument. The example
is another way to alias names as used in X11 fonts to the MIME names for the iso-8859-* family.
Alias overloading
You can override predefined aliases by simply applying define_alias(). The new alias is always evaluated first, and when neccessary,
define_alias() flushes the internal cache to make the new definition available.
# redirect SHIFT_JIS to MS/IBM Code Page 932, which is a
# superset of SHIFT_JIS
define_alias( qr/shift.*jis$/i => '"cp932"' );
define_alias( qr/sjis$/i => '"cp932"' );
If you want to zap all predefined aliases, you can use
Encode::Alias->undef_aliases;
to do so. And
Encode::Alias->init_aliases;
gets the factory settings back.
SEE ALSO
Encode, Encode::Supported
perl v5.8.0 2002-06-01 Encode::Alias(3pm)