Hi,
I have a file with multiple records...and I have to select records based on first column....here is the sample file...
I01,abc,125,1a2,LBVI02
I01,abc,126,2b5,LBVI02
I02,20070530,254,abc,LLBI01
I02,20070820,111,bvd,NGBI01
I need all records with I01 in first field in one file and... (8 Replies)
I've a file like this:
andrea andre@lol.com october
antonio@lol.com
marco 45247@pop.com
kk@pop.com may
pollo@lol.com
mary mary@lol.com
can I select only the column with email adress?
can I utilise a filter with @ ?
I want obtain this:
... (2 Replies)
Hi,
Following is my file output
247 Sleep 25439 NULL
259 Sleep 25460 NULL
277 Sleep 15274 NULL
361 Sleep 2 NULL
362 Sleep 202 NULL
I want to select only first column to other file
How can... (2 Replies)
How can I use awk to pick a particular column and work on it? For example, I want to count the number of characters in column10 that are separated by |?
Thank you. (2 Replies)
I know I know..
for sure one of the easier mysql statements. But somehow I can not figure out this.
I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row)
data_12 ... (6 Replies)
the input is : 6298 | anna | chennai | 7/4/08
3981 | dastan | bagh | 8/2/07
6187 | galma | london | 9/5/01
3728 | gonna | kol | 8/2/10
3987 | hogja | mumbai | 8/5/09
2898 | homy | pune | 7/4/09
9167 | tamina | ny | 8/3/10
4617 | vazir | ny
now how to get the following output : 3987 |... (4 Replies)
Hi!
From a file the format of whichis as in the sample here below, I need to get two files having just 2 columns, being - for the first file - the 2nd than the 1st from the original file; and - for the second file - the LAST then the 1st column of the original file.
Moreover, I would sort the... (3 Replies)
Hi all,
Am using awk to reformat an existing file
cat $INP_FILE1 | while read line
do
echo "$line" | nawk ' BEGIN {FS=","} {print("5",$1,$28,"$27",$26)}' >> $OUT_FILE1
done
my question is, i would like to read lines that are starting with particular value only example
... (9 Replies)
I want records which have more than one and different value in the second column on the below sample file.
Ex, I have the samle file below :-
XYZ 1
XYZ 3
abc 1
abc 1
qwe 2
qwe 1
qwe 3
I want to select XYZ and QWE line only. (6 Replies)
Hi all,
Am trying to write a menu driven script using SELECT and if I have more than 4 options, it wraps to the next column. That is if I have 6 choices, items 5 and 6 are in the second column.
Is there any settings that control this behavior or is it due to some stty settings?
stty -a... (3 Replies)
Discussion started by: newbie_01
3 Replies
LEARN ABOUT DEBIAN
alzabo::runtime::inserthandle
Alzabo::Runtime::InsertHandle(3pm) User Contributed Perl Documentation Alzabo::Runtime::InsertHandle(3pm)NAME
Alzabo::Runtime::InsertHandle - A handle representing an insert
SYNOPSIS
my $handle =
$table->insert_handle
( columns => [ $table->columns( 'name', 'job' ) ] );
my $faye_row =
$handle->insert( values =>
{ name => 'Faye',
job => 'HK Pop Chanteuse' } );
my $guesch_row =
$handle->insert( values =>
{ name => 'Guesch',
job => 'French Chanteuse and Dancer' } );
DESCRIPTION
This object is analogous to a DBI statement handle, and can be used to insert multiple rows into a table more efficiently than repeatedly
calling "Alzabo::Runtime::Table->insert()".
METHODS
Objects of this class provide one public method:
insert
This method is used to insert a new row into a table.
It accepts the following parameters:
* values
This should be a hash reference containing the values to be inserted into the table.
If no value is given for a primary key column and the column is "sequenced" then the primary key will be auto-generated.
If values are not provided for other columns which were given when "Alzabo::Runtime::Table->insert_handle" was called, this method
first checks to see if a value was provided for the column when "Alzabo::Runtime::Table->insert_handle" was called. If none was pro-
vided, then the column's default value is used.
If column values were passed to "Alzabo::Runtime::Table->insert_handle", then these can be overridden by values passed to this method.
It is not possible to override column values that were given as SQL functions when "Alzabo::Runtime::Table->insert_handle" was called.
This method returns a new "Alzabo::Runtime::Row" object.
Throws: "Alzabo::Exception::Logic", "Alzabo::Exception::Params"
perl v5.8.8 2007-12-23 Alzabo::Runtime::InsertHandle(3pm)