Sponsored Content
Top Forums Shell Programming and Scripting extract words from txt using perl Post 302381441 by eng_shimaa on Friday 18th of December 2009 07:13:57 AM
Old 12-18-2009
Thanks very much now the task begin to be easy but sorry i will have questions while i am going ahead with that.( as really it is the first time for me to use perl)

About the connection with mysql this is the perl function as i wrote it in a notebad and saved it begin.pl and i went to command prompt and i wrote

C:\Perl\eg\begin.pl

the code in the begin.pl is

PHP Code:
#!/usr/bin/perl
BEGIN {
# PERL MODULES WE WILL BE USING
use DBI;
use 
DBD::mysql;
$dbh DBI->connect('DBI:mysql:db1''person') || die "Could not connect to database: $DBI::errstr";}
# (insert query examples here...)
$sth $dbh->prepare('SELECT describtion FROM protein_names where gene_name=AMELY');
$sth->execute();
$result $sth->fetchrow_hashref();
print 
"Value returned: $result->{description}\n";
 
end{
$dbh->disconnect();


but the code don't work and when i type the path

C:\Perl\eg\begin.pl in the command prompt the answer is :
is not recognized as internal or external command

Note: i made sure that the perl has the modules which i used above
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to extract two words at the same time.

Hi, Can anyone please let me know, how to extract two lines at the same time. In specific,I have a file containing list of devices, such as router1 and switch2 below. I want to get all the lines which has "#" and all the lines which has "down" router1#sh ip int br Interface ... (6 Replies)
Discussion started by: Aejaz
6 Replies

2. Shell Programming and Scripting

Extract from txt file

I have data as follow in the txt file. I want to skip line starting with '#' sign. #command program abc defmt exp refmt ... ... I want to store abc exp .... in a array. I want to store defmt refmt in a array I need command to read each line in the file. I need... (6 Replies)
Discussion started by: ekb
6 Replies

3. UNIX for Dummies Questions & Answers

Extract numbers from .txt file

I need to extract all the p-value numbers and the rho numbers from a .txt file and write them as coma separated values in a new file. Ideally I would get two files in the end, one for p- values and one for rho. Any suggestions? I appreciate your help!!! The .txt file looks essentially like this... (5 Replies)
Discussion started by: eggali
5 Replies

4. UNIX for Dummies Questions & Answers

Extract words to new file

Hi there, Unix Gurus Working with big listings of english sentences for my pupils, of the type: 1. If the boss's son had been , someone would have asked for money by now. 2. Look, I haven't a crime, so why can't you let me go? .... I wondered how to extract the words between brackets in... (7 Replies)
Discussion started by: eldeingles
7 Replies

5. Shell Programming and Scripting

Extract words from a pipe

Hello, Currently, I have this output from my application : ------------------------------------------------- Log viewer/Tmp1 (Jun 29 2011 09:48) ------------------------------------------------- BlalbalbaBlalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba..Blalbalba....... (3 Replies)
Discussion started by: acidoangel
3 Replies

6. Shell Programming and Scripting

grep words from txt

Queue on node in domain description : type : local max message len : 104857600 max queue depth : 5000 queue depth max event : enabled persistent msgs : yes backout threshold : 0 msg delivery seq :... (4 Replies)
Discussion started by: Daniel Gate
4 Replies

7. Shell Programming and Scripting

Extract the filename and write to .txt

I'm new to this forum and also to UNIX scripting. I need a command to extract the filename from the path and write to .txt file. Thanks in advance for your guidance. (23 Replies)
Discussion started by: Ram Kumar_BE
23 Replies

8. Shell Programming and Scripting

Extract words before and after a certain word.

I have a sample text file with file name: sample.txt The text file has the following text. this is an example text where we have to extract certain words before and after certain word these words can be used later to get more information I want to extract n (a constant) words before and... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies

9. UNIX for Beginners Questions & Answers

Extract Bracketed Words

Hi there, Unixers I need to extract ALL the words from a text which aresurrounded by square brackets. I am using this piece of code sed 's/.*\.*/\1/g' inputfile > outputfile but I only get one word for every paragraph, why? Please use CODE tags as required by forum rules! (7 Replies)
Discussion started by: eldeingles
7 Replies

10. Shell Programming and Scripting

Awk, sed, shell all words in INPUT.txt find in column1 of TABLE.txt and replce with column2 in

Hi dears i have text file like this: INPUT.txt 001_1_173 j nuh ]az 001_1_174 j ]esma. nuh ]/.xori . . . and have another text like this TABLE.txt j j nuh word1... (6 Replies)
Discussion started by: alii
6 Replies
DBIx::Connector::Driver(3pm)				User Contributed Perl Documentation			      DBIx::Connector::Driver(3pm)

Name
       DBIx::Connector::Driver - Database-specific connection interface

Description
       Some of the things that DBIx::Connector does are implemented differently by different drivers, or the official interface provided by the
       DBI may not be implemented for a particular driver. The driver-specific code therefore is encapsulated in this separate driver class.

       Most of the DBI drivers work uniformly, so in most cases the implementation provided here in DBIx::Connector::Driver will work just fine.
       It's only when something is different that a driver subclass needs to be added. In such a case, the subclass's name is the same as the DBI
       driver. For example the driver for DBD::Pg is DBIx::Connector::Driver::Pg and the driver for DBD::mysql is DBIx::Connector::Driver::mysql.

       If you're just a user of DBIx::Connector, you can ignore the driver classes.  DBIx::Connector uses them internally to do its magic, so you
       needn't worry about them.

Interface
       In case you need to implement a driver, here's the interface you can modify.

   Constructor
       "new"

	 my $driver = DBIx::Connector::Driver->new( $driver );

       Constructs and returns a driver object. Each driver class is implemented as a singleton, so the same driver object is always returned for
       the same driver.  The "driver" parameter should be a Perl DBI driver name, such as "Pg" for DBD::Pg or "SQLite" for DBD::SQLite. If a
       subclass has been defined for $driver, then the object will be of that class.  Otherwise it will be an instance of the driver base class.

   Instance Methods
       "ping"

	 $driver->ping($dbh);

       Calls "$dbh->ping". Override if for some reason the DBI driver doesn't do it right.

       "begin_work"

	 $driver->begin_work($dbh);

       Calls "$dbh->begin_work". Override if for some reason the DBI driver doesn't do it right.

       "commit"

	 $driver->commit($dbh);

       Calls "$dbh->commit". Override if for some reason the DBI driver doesn't do it right.

       "rollback"

	 $driver->rollback($dbh);

       Calls "$dbh->rollback". Override if for some reason the DBI driver doesn't do it right.

       "savepoint"

	 $driver->savepoint($dbh, $name);

       A no-op. Override if your database does in fact support savepoints. The driver subclass should create a savepoint with the given $name. See
       the implementations in DBIx::Connector::Driver::Pg and DBIx::Connector::Driver::Oracle for examples.

       "release"

	 $driver->release($dbh, $name);

       A no-op. Override if your database does in fact support savepoints. The driver subclass should release the savepoint with the given $name.
       See the implementations in DBIx::Connector::Driver::Pg and DBIx::Connector::Driver::Oracle for examples.

       "rollback_to"

	 $driver->rollback_to($dbh, $name);

       A no-op. Override if your database does in fact support savepoints. The driver subclass should rollback to the savepoint with the given
       $name. See the implementations in DBIx::Connector::Driver::Pg and DBIx::Connector::Driver::Oracle for examples.

Authors
       This module was written and is maintained by:

       David E. Wheeler <david@kineticode.com>

       It is based on code written by:

       Matt S. Trout <mst@shadowcatsystems.co.uk>
       Peter Rabbitson <rabbit+dbic@rabbit.us>

Copyright and License
       Copyright (c) 2009-2010 David E. Wheeler. Some Rights Reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2012-06-03					      DBIx::Connector::Driver(3pm)
All times are GMT -4. The time now is 04:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy