How to match fields surrounded by double quotes with commas?
Hello to all,
I'm trying to match only fields surrounded by double quotes that have one or more commas inside.
The text is like this
The matches should be
I'm trying with the regex below, but is matching all fields surrounded by double quotes, even those that
don't have any comma inside.
Hi,
I'm making progress on this but hung up on one last detail. I'd like to use AWK to pass the system date and time(among other things) to the first line of a file.
Here's what I have:
BEGIN {TOTALPP = 0;FREEPP=0;USEDPP=0;print "LPAR NAME:",lpar,"DATE:",tdate }
I call AWK with the... (4 Replies)
Excuse the terrible title.
I have a text file of 1..n lines, each one containing at least one string between parentheses. Within each string, there is one or more strings separated by commas. I need to extract each string, thus:
input file:
(THIS,THAT)
(THE,OTHER)
(THING)
(OR,MAYBE)... (6 Replies)
Hi,
my requirement is to find the count of commas in a string excluding the ones in double quotes.
For example:
If the input string is
abc,xyz.com,lmhgdf,"abc, 401 street","tty,stt",45,23,45
The output should be 7 (7 Replies)
I am trying to match a text which contains the " ", from the log file. But it doesn't match. I understand that " " has got a special meaning to TCL/Expect.
hence I tried the following, but no luck.
expect -ex {
"lp -c -demail -ot\\\"firstname_surname@gmail.com\\\"... (3 Replies)
Hello experts,
I need to validate a csv file which contains data like this:
Sample.csv
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
I just need to check if all the records contain exactly the number of... (5 Replies)
Hi,
I have an input file like this
$ cat infile
hi,i,"am , sam", y
hello ,good, morning
abcd, " ef, gh " ,ij
no, "good,morning", yes, "good , afternoon"
from this file I have to split the fields on basis of comma"," however, I the data present inside double qoutes should be treated as... (3 Replies)
I am trying to re-format a .csv file using awk. I have 6 fields in the .csv file. Some of the fields are enclosed in double quotes and contain comma's inside the quotes. awk is breaking this into multiple fields.
Sample lines from the .csv file:
Device Name,Personnel,Date,Solution... (1 Reply)
Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote.
Please see the sample file as below:
column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10... (8 Replies)
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)
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)
Discussion started by: mlavanya
6 Replies
LEARN ABOUT OSX
encode::alias5.16
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);
define_alias( qr/.../ => ENCODING);
define_alias( sub { return ENCODING if ...; } );
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 the first argument to define_alias() 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.
(or, you don't have to do this yourself because this example is predefined)
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 this feature with caution.
As a code reference, e.g.:
define_alias( sub {shift =~ /^iso8859-(d+)$/i ? "iso-8859-$1" : undef } );
The same effect as the example above in a different way. The coderef takes the alias name as an argument and returns a canonical name
on success or undef if not. Note the second argument is ignored if provided. Use this with even more caution than the regex version.
Changes in code reference aliasing
As of Encode 1.87, the older form
define_alias( sub { return /^iso8859-(d+)$/i ? "iso-8859-$1" : undef } );
no longer works.
Encode up to 1.86 internally used "local $_" to implement ths older form. But consider the code below;
use Encode;
$_ = "eeeee" ;
while (/(e)/g) {
my $utf = decode('aliased-encoding-name', $1);
print "position:",pos,"
";
}
Prior to Encode 1.86 this fails because of "local $_".
Alias overloading
You can override predefined aliases by simply applying define_alias(). The new alias is always evaluated first, and when necessary,
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.
Note that define_alias() will not be able to override the canonical name of encodings. Encodings are first looked up by canonical name
before potential aliases are tried.
SEE ALSO
Encode, Encode::Supported
perl v5.16.2 2012-10-25 Encode::Alias(3pm)