02-02-2007
A Doozy of a problem for me
I have a report I need to format into a nice looking fixed length for each column of output
The report looks like this
1. First Query Title
First Query syntax (select * from tablea)
column1a ,column2a
ROWDATA.......
ROWDATA.......
ROWDATA ......
2. Second Query Title
Second Query syntax (select * from tableb)
column1b ,column2b
ROWDATA ......................................................,ROWDATA
ROWDATA.......................................................,ROWDATA
3. Third Query Syntax
Second Query syntax (select * from tablec)
column1c ,column2c
ROWDATA.................................,ROWDATA
ROWDATA.................................,ROWDATA
As you can see the column width varies from each query result set.
how can I format this report to find the end of each column yes they are all separated by commas and add only one space in order to compact the report.
The dots in each row represents a space
This one is really tough for me
any help is greatly appreciated.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, folks.
Sorry for bothering, but maybe someone could help me please.
The problem is the following:
there is some script that copies files from local file system to AFS. The copying is performed with dd command.
The script copies data into some AFS volumes.
The problem appeared with one... (0 Replies)
Discussion started by: Anta
0 Replies
2. Shell Programming and Scripting
Hi
Please help me with the following problem with my script.
The following block of code is not repeating in the while loop and exiting after searching for first message.
input_file
==========
host001-01
host001-02
2008-07-23 13:02:04,651 ConnectionFactory - Setting session state... (2 Replies)
Discussion started by: pcjandyala
2 Replies
3. Solaris
Hi
I am right now facing a strange hardware problem. System get booted with the following error:
Fatal Error Reset
CPU 0000.0000.0000.0003 AFSR 0100.0000.0000.0000 SCE
AFAR 0000.07c6.0000.1000
SC Alert: Host System has Reset
It happen 4 or 5 times and get the same error every time.I... (8 Replies)
Discussion started by: girish.batra
8 Replies
4. AIX
1) when user login to the server the session got colosed. How will resolve?
2) While firing the command ls -l we are not able to see the any files in the director. but over all view the file system using the command df -g it is showing 91% used. what will be the problem?
Thanks in advance. (1 Reply)
Discussion started by: pernasivam
1 Replies
5. Red Hat
Hi,
i've a redhat linux 9 upadated by redhat from 7 version to 9 version. A couple of days ago i was a problem with my mail, in other words i'm not able to get any email nor to send any email. I've a proxy configuration and i tried to set iptables in order to verify the port. The 110,255 and 995... (1 Reply)
Discussion started by: pintalgi
1 Replies
6. UNIX for Dummies Questions & Answers
At work I am trying to get this one Linux machine (let's call it ctesgm07) to behave like another Linux machine that we have (let's call it test007).
test007 returns the following version info:
cat /etc/debian_version: lenny/sid
uname -a: Linux test007 2.6.27-7-generic #1 SMP Tue Nov 4... (0 Replies)
Discussion started by: sllinux
0 Replies
7. AIX
Dear ALL.
I installed AIX OS on customer sites.
but Only one site is too slow when I connected telnet, ftp..
Ping is too fast. but telnet and FTP is not connected..
of course i check the configuration file on aix but it's normal.
Do any Idea??
thanks in advance.
- Jun - (3 Replies)
Discussion started by: Jeon Jun Seok
3 Replies
8. IP Networking
Hi,
This is rather a question from a "user" than from a sys admin, but I think this forum is apropriate for the question.
I have an adress with automatic email forwarding and for some senders (two hietherto), emails are bouncing. This has really created a lot of problems those two time so I... (0 Replies)
Discussion started by: carwe
0 Replies
9. UNIX for Dummies Questions & Answers
I don't know if you guys get this problem sometimes at Terminal but I had been having this problem since yesterday :( Maybe I overdid the Terminal. Even the codes that used to work doesn't work anymore.
Here is what 's happening:
* I wanted to remove lines containing digits so I used this... (25 Replies)
Discussion started by: Nexeu
25 Replies
10. IP Networking
Hi everyone,
I am experiencing discontinuity of Internet service, this started 1 month ago. Everything worked very well for 1 year of intensive use, but now, I have problems reaching my gateway.
The gateway is not my router but a node belonging to my ISP and I share the same public IP with... (3 Replies)
Discussion started by: remic
3 Replies
LEARN ABOUT DEBIAN
rdf::helper::rdfredland::query
RDF::Helper::RDFRedland::Query(3pm) User Contributed Perl Documentation RDF::Helper::RDFRedland::Query(3pm)
NAME
RDF::Helper::RDFReland::Query - Perlish convenience extension for RDF::Redland::Query
SYNOPSIS
my $model = RDF::Redland::Model->new(
RDF::Redland::Storage->new( %storage_options )
);
my $rdf = RDF::Helper->new(
Namespaces => \%namespaces,
BaseURI => 'http://domain/NS/2004/09/03-url#'
);
my $q_obj = $rdf->new_query( $sparql_text, 'sparql' );
# arrays
while ( my $row = $q_obj->selectrow_arrayref ) {
# $row is an array reference.
}
# hashes
while ( my $row = $q_obj->selectrow_hashref ) {
# $row is a hash reference.
}
DESCRIPTION
RDF::Helper::RDFRedland::Query is the object retuned from RDF::Helper's new_query() method when using RDF::Redland as the base interface
class. This object provides everything that an instance of RDF::Redland::Query offers, plus the convenience methods detailed below.
METHODS
selectrow_arrayref
Returns each row as a Perl array references. The order of the array's indices will correspond to the order of the variable bindings in the
query.
selectrow_hashref
Returns each row as a Perl hash references. The keys in the hash will have the same names as the variable bindings in the query.
AUTHOR
Kip Hampton, khampton@totalcinema.com
COPYRIGHT
Copyright (c) 2004 Kip Hampton. =head1 LICENSE
This module is free sofrware; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
RDF::Helper RDF::Redland::Query.
perl v5.14.2 2011-06-24 RDF::Helper::RDFRedland::Query(3pm)