Sponsored Content
Full Discussion: A Doozy of a problem for me
Top Forums Shell Programming and Scripting A Doozy of a problem for me Post 302105552 by zilla30066 on Friday 2nd of February 2007 02:57:25 PM
Old 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

problem with dd command or maybe AFS problem

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

ssh script problem problem

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

problem in finding a hardware problem

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

user login problem & Files listing problem.

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

Mail Problem. Maybe, it is a DNS Problem!

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

DHCP problem and eth1 problem

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

AIX OS problem? network problem?

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

Problem with forwarding emails (SPF problem)

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

sed Or Grep Problem OR Terminal Problem?

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

Router problem or ISP problem ?

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
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)
All times are GMT -4. The time now is 10:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy