08-20-2009
Hi Durden , I got confused. let me write it clearly here.
I have a outfile generated like this.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
abc
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
def
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
ghi
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
jkl
Now i need the output as
abc
def
ghi
jkl
sorry for the confusion.
THanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
I have a directory that holds all of my matlab codes. I am trying to run a searh on all of the matlab files that have the word "while" written inside the sytax of the code.
Looking for all of the times that I did a while loop.
Can someone help me do this?
Thanks in advance.
... (1 Reply)
Discussion started by: moradwan
1 Replies
2. UNIX for Dummies Questions & Answers
hi all
i want to search some word in file but i want that it will search in all the files that i have
in all the directories i do'nt know the name of the file
i know that grep command want some specified file
in which command shell i used
thanks (2 Replies)
Discussion started by: naamas03
2 Replies
3. Shell Programming and Scripting
Hello everyone!
I use a script to query for installed packages with yum (I use RHEL 4 with yum installed) and the output is redirected to a file. My script scan this file to find a package and the version of it.
The script works fine until I search for a package name with special characters.... (3 Replies)
Discussion started by: studieu
3 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
I have a log file which is more than 1GB, i need to take count from the log file for two strings. i am using the below command but it take a long time to excetue, i need to tune this. Please help me
cat /logs/gcbs/gcbsTrace.log | grep -i "ViewStatementBusinessLogic" | grep -c -i... (8 Replies)
Discussion started by: senthilkumar_ak
8 Replies
5. Shell Programming and Scripting
i want to search in the current directory all the files that contain one word for example "hello"
i want to achieve it with the grep command but not with the grep * (2 Replies)
Discussion started by: aintour
2 Replies
6. Shell Programming and Scripting
Hi, I am new to Unix and this is my first post on this forum. I am trying to convert a file into an xml. In my input I want to search for any line that starts with a 'F' and make it a tag in the xml.
See below for the input and output.
Input :
<Payment>
<REFERENCE>78</REFERENCE>
F123 : ... (7 Replies)
Discussion started by: akashgov
7 Replies
7. Shell Programming and Scripting
Hi All,
I have a issue in pulling some heavy records , I have my input file has 10,000 records which i need to compare with daily appended log files from (sep 1st 2009 to till date) . I tried to use grep fgrep and even sed , but the as time is factor for me , i cannot wait for 5 days to get the... (3 Replies)
Discussion started by: rakesh_411
3 Replies
8. UNIX for Dummies Questions & Answers
I have a file that has the words I want to find in other files (but lets say I just want to find my words in a single file). Those words are IDs, so if my word is ZZZ4, outputs like aaZZZ4, ZZZ4bb, aaZZZ4bb, ZZ4, ZZZ, ZyZ4, ZZZ4.8 (or anything like that) WON'T BE USEFUL.
I need the whole word... (6 Replies)
Discussion started by: chicchan
6 Replies
9. Shell Programming and Scripting
Hi,
i have a directory structure which contains few files each.
each file in turn has some functions. i'm searching for a word, say 'pen' in all the files present in all the directories. :wall:
consider a file file1.c in Dir1. out of the 3 funcs present in this file, func1(pennum) and... (3 Replies)
Discussion started by: i.srini89
3 Replies
10. Shell Programming and Scripting
Hi,
I need a script to start searching a word from the particular record on the result of first occurence i need to change the value in that record.
I have a input file like this
<properties>
<add key="DeliveryWithinDay" value="False" />
<add key="ABC" value="23:00:00 PM" />
<add... (5 Replies)
Discussion started by: NareshN
5 Replies
LEARN ABOUT OSX
sql::translator::parser::dbix::class
SQL::Translator::Parser::DBIx::Class(3) User Contributed Perl Documentation SQL::Translator::Parser::DBIx::Class(3)
NAME
SQL::Translator::Parser::DBIx::Class - Create a SQL::Translator schema from a DBIx::Class::Schema instance
SYNOPSIS
## Via DBIx::Class
use MyApp::Schema;
my $schema = MyApp::Schema->connect("dbi:SQLite:something.db");
$schema->create_ddl_dir();
## or
$schema->deploy();
## Standalone
use MyApp::Schema;
use SQL::Translator;
my $schema = MyApp::Schema->connect;
my $trans = SQL::Translator->new (
parser => 'SQL::Translator::Parser::DBIx::Class',
parser_args => {
package => $schema,
add_fk_index => 0,
sources => [qw/
Artist
CD
/],
},
producer => 'SQLite',
) or die SQL::Translator->error;
my $out = $trans->translate() or die $trans->error;
DESCRIPTION
This class requires SQL::Translator installed to work.
"SQL::Translator::Parser::DBIx::Class" reads a DBIx::Class schema, interrogates the columns, and stuffs it all in an $sqlt_schema object.
Its primary use is in deploying database layouts described as a set of DBIx::Class classes, to a database. To do this, see "deploy" in
DBIx::Class::Schema.
This can also be achieved by having DBIx::Class export the schema as a set of SQL files ready for import into your database, or passed to
other machines that need to have your application installed but don't have SQL::Translator installed. To do this see "create_ddl_dir" in
DBIx::Class::Schema.
PARSER OPTIONS
add_fk_index
Create an index for each foreign key. Enabled by default, as having indexed foreign key columns is normally the sensible thing to do.
sources
Arguments: @class_names
Limit the amount of parsed sources by supplying an explicit list of source names.
SEE ALSO
SQL::Translator, DBIx::Class::Schema
AUTHORS
See "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.16.2 2012-08-16 SQL::Translator::Parser::DBIx::Class(3)