08-18-2008
redoubtable, thanks for sharing that, I think that's definitely what vanitham is looking for. Yogesh's suggestion is also a ray of light, I was almost sure there's a perl module for that, but I couldn't find it
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
Vanitha, now you can construct SQL query, store the output somewhere, and then process it with some of the suggested methods above.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
How to separate numbers and words(with full alphabets) in a particular file and store it in two different files.
Please help me out for this.Using shell scripting.
:confused::confused: (1 Reply)
Discussion started by: kamakshi s
1 Replies
2. Shell Programming and Scripting
Hi all,
Please some help over here. I have a Sales.txt file containing info in blocks for
every sold product in the pattern showed below (only for 2 products).
NEW BLOCK
SALE DATA
PRODUCT SERIAL
79833269999 146701011945004
.Some other data
.Some... (17 Replies)
Discussion started by: cgkmal
17 Replies
3. Shell Programming and Scripting
Hi,
I have to write a shell script that converts numbers in to words
below is what i wrote.My script is not running.
-----------------------------------
echo -n "Enter number : "
read n
len= echo $n | wc -c
echo " number in words : "
for ( i=1; i<len; i++ )
do
num=echo $n... (5 Replies)
Discussion started by: bab123
5 Replies
4. Shell Programming and Scripting
Hi guys,
I have got a file which doesn't have the same number of columns in each line. I would like to print the second column and the one that begins with 33= and has some numbers after '33='
Can you please help me asap?
Cheers (7 Replies)
Discussion started by: alexandra_ola
7 Replies
5. Shell Programming and Scripting
Hi All,
I have searched the forum and tried to print only matching(pattern) words from the file, but its printing entire line. I tried with grep -w. I am on sunsolaris.
Eg:
cat file
A|A|F1|F2|A|F3|A
A|F10|F11|F14|A|
F20|A|F21|A|F25
I have to search for F (F followed by numbers) and ... (5 Replies)
Discussion started by: gsjdrr
5 Replies
6. Shell Programming and Scripting
Hi,
Sorry in advance for propably a silly question, but I am a bit lost.
On some of the linux job flow I have the following check:
if ($file != 1500) then
echo ERROR
It works ok, all times $file is not equal to 1500 I have the error message.
I try to do something similar... (7 Replies)
Discussion started by: essemario
7 Replies
7. UNIX for Dummies Questions & Answers
Hi. I have a file containing words and numbers associated with them as follows -
c 2
b 5
c 5
b 6
a 10
b 16
c 18
a 19
b 21
c 27
a 28
b 33
a 76
a 115
c 199
c 251
a 567
a 1909 (4 Replies)
Discussion started by: maq
4 Replies
8. Shell Programming and Scripting
Hi All,
I tried to solve this but the result gives me all zeros for one file. I failed to do for all 500 files.
I have some 500 files with the extension .dat I have another set of files; 500 in number with extension .dic I created these .dic files by using sort -u from the actual .dat files.... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies
9. Shell Programming and Scripting
Hi All,
I have a file which looks like this:
abc 1
abc 2
abc 3
abc 4
abc 5
bcd 1
bcd 3
bcd 3
bcd 5
cde 7
This file is just a miniature version of what I really have. Original file is some 1 million lines long.
I have tried to come up with the code for what I wish to accomplish... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies
10. UNIX for Dummies Questions & Answers
##### (0 Replies)
Discussion started by: lucasvs
0 Replies
LEARN ABOUT SUSE
sql::statement::termfactory
SQL::Statement::TermFactory(3) User Contributed Perl Documentation SQL::Statement::TermFactory(3)
NAME
SQL::Statement::TermFactory - Factory for SQL::Statement::Term instances
SYNOPSIS
my $termFactory = SQL::Statement::TermFactory->new($stmt);
my $whereTerms = $termFactory->buildCondition( $stmt->{where_clause} );
my $col = $termFactory->buildCondition( $stmt->{col_obj}->{$name}->{content} );
DESCRIPTION
This package implements a factory to create type and operation based terms. Those terms are used to access data from the table(s) - either
when evaluating the where clause or returning column data.
The concept of a factory can be studied in Design Patterns by the Gang of Four. The concept of using polymophism instead of conditions is
suggested by Martin Fowler in his book Refactoring.
METHODS
buildCondition
Builds a condition object from a given (part of a) where clause. This method calls itself recursively for predicates.
AUTHOR AND COPYRIGHT
Copyright (c) 2001,2005 by Jeff Zucker: jzuckerATcpan.org Copyright (c) 2008-2010 by Jens Rehsack: rehsackATcpan.org
Portions Copyright (C) 1998 by Jochen Wiedmann: jwiedATcpan.org
All rights reserved.
You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
README file.
perl v5.12.1 2010-05-06 SQL::Statement::TermFactory(3)