I have in file these words:
@fraza1 = rw
@fraza2 = r
@fraza3 = r
@fraza4 = r
@fraza5 = r
@fraza1 = r
@fraza6 = r
@fraza7 = r
@fraza2 = r
@fraza8 = r
@fraza9 = r
...
I would like so that:
,rw,@fraza1
,r,@fraza2 (2 Replies)
Hi,
I am trying to fetch some values from db and spooling the output to a file.
when i query the db for the values, i get the values in following format.
PC_1 wf_test1 Test
PC_2 wf_test2 Test
PC_3 wf_test3 Test
But my spool file was created in following format.
PC_1
wf_test1
Test... (20 Replies)
I have a script which converts rows to columns.
file_name=$1
mailid=$2
#CREATE BACKUP OF ORIGINAL FILE
#cp ${file_name}.xlsx ${file_name}_temp.xlsx
#tr '\t' '|' < ${file_name}_temp.xlsx > ${file_name}_temp.csv
#rm ${file_name}_temp.xlsx
pivot_row=`head -1 ${file_name}`
sed 1d... (3 Replies)
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Hi I'm a UNIX awk and sed novice at best. I'm trying to creat a .csv file so it can be graphed in Excel. Tried various xargs, awk, sed and paste but just can't seem to get the data to line up. Not sure if this is beyond for a question in these forums. Any help would greatly be appreciated.
Have... (4 Replies)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
hi all
I need a help ..I have a script that takes has command and its output is like below..
a b
a v v
a c
I am assigning the above outputs to a variable ..
<variable name> = <command output>
problem here is when I echo the variable ..it gives me output like " a b... (3 Replies)
I've spent the past hour trying different things and googling for this solution and cannot find the answer. Found variations of this, but not this exact thing.
I have the following text, which is the output from our mainframe. Each field is on a separate line, with a blank line between each... (7 Replies)
Discussion started by: lupin..the..3rd
7 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)