Hi all,
I have a logfile which has lines as following:
DOMAIN\username,Deposit,DOMAIN\ServiceAccountName,25/03/2010,00:10,\\SERVER,,,,/Ts=4BAA9BD6,,,10.00,10.03
It's a log of a pcounter print charge system.
I need to only have the first part (domain\username) and the second last... (4 Replies)
Hi Everyone,
1.txt
test here (888_f)a/fff (eeee) test2 (q)--(qq)
the output is
test here a/fff test2 --
means remove the characters in between (), and () itself. Please advice.
Thanks (3 Replies)
Hi everyone,
suppose that I have the following line:
#test your knowledge
can I use AWK to print the word "test" only? without the #?
what should I change to this:
awk '{print $1}'
thanks in advance guys (2 Replies)
I have the following code for removing duplicate records based on fields in inputfile file & moves the duplicate records in duplicates file(1st Awk) & in 2nd awk i fetch the non duplicate entries in inputfile to tmp file and use move to update the original file.
Requirement:
Can both the awk... (4 Replies)
Hi All,
I have searched many threads for possible close solution. But I was unable to get simlar scenario.
I would like to print all duplicate based on 3rd column except the first occurance. Also would like to print if it is single entry(non-duplicate).
i/P file
12 NIL ABD LON
11 NIL ABC... (6 Replies)
I would like to remove lines with certain pattern but only Estimate: and Realised: in USD and Date: shall be output. The order of the currency are mixed.
Output
I failed on awk with sub, gensub and was not able to remove the multiple entry on the * Date: (2 Replies)
Hi Everybody:
I need your help, please...
I have this file *.txt
0000 | 16010201 22000000 67892000 00000000 00000000 00000100 72246681 28E08236
| ~~~~"~~~g~ ~~~~~~~~~~~~~r$f~(~~6 |
0020 | 10476173 90010100 10000000 00000001 05000226 17163011 12442212 48140484
|... (2 Replies)
Discussion started by: solaris21
2 Replies
LEARN ABOUT DEBIAN
data::stream::bulk::dbi
Data::Stream::Bulk::DBI(3pm) User Contributed Perl Documentation Data::Stream::Bulk::DBI(3pm)NAME
Data::Stream::Bulk::DBI - N-at-a-time iteration of DBI statement results.
VERSION
version 0.11
SYNOPSIS
use Data::Stream::Bulk::DBI;
my $sth = $dbh->prepare("SELECT hate FROM sql"); # very big resultset
$sth->execute;
return Data::Stream::Bulk::DBI->new(
sth => $sth,
max_rows => $n, # how many at a time
slice => [ ... ], # if you want to pass the first param to fetchall_arrayref
);
DESCRIPTION
This implementation of Data::Stream::Bulk api works with DBI statement handles, using "fetchall_arrayref" in DBI.
It fetches "max_rows" at a time (defaults to 500).
ATTRIBUTES
sth The statement handle to call "fetchall_arrayref" on.
slice
Passed verbatim as the first param to "fetchall_arrayref". Should usually be "undef", provided for completetness.
max_rows
The second param to "fetchall_arrayref". Controls the size of each buffer.
Defaults to 500.
METHODS
get_more
See Data::Stream::Bulk::DoneFlag.
Calls "fetchall_arrayref" to get the next chunk of rows.
all Calls "fetchall_arrayref" to get the raminder of the data (without specifying "max_rows").
AUTHOR
Yuval Kogman <nothingmuch@woobling.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Yuval Kogman.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-02-14 Data::Stream::Bulk::DBI(3pm)