07-16-2008
Need to print certain lines from a file
Hi ALL,
I want to print lines from file using certain conditions
for exmple:
# The following commands will create a new control file and use it
# to open the database.
# The contents of online logs will be lost and all backups will
# be invalidated. Use this only if online logs are damaged.
;
ALTER DATABASE OPEN;
SIZE 2000M REUSE AUTOEXTEND OFF;
SIZE 2000M REUSE AUTOEXTEND OFF;
;
ALTER DATABASE OPEN RESETLOGS;
SIZE 2000M REUSE AUTOEXTEND OFF;
SIZE 2000M REUSE AUTOEXTEND OFF;
here i want to print lines between first occurance of ";" and second occurance of it.
Thanks
Jack
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have a text file and I want to clean up the file by only print those lines start with the date. Is there anyway I can do that?
Thanks
CT (1 Reply)
Discussion started by: CamTu
1 Replies
2. UNIX for Dummies Questions & Answers
It my first post here .
I just want to get the content of the file as values for printinting along with line number in LINUX
Here is what I tried .
$ cat test1.txt
ABC
DSF
GHI
JKL
MNO
PQR
STU
VWX
YZO
$ cat test.sh
#!/bin/ksh (4 Replies)
Discussion started by: rajavu
4 Replies
3. Shell Programming and Scripting
Hi All,
File that I have:
<ct>
<name>group
<value>1
<value>2
<value>3
</ct>-->file
The output that I needed is
<ct>
<name>group
<value>1 -->file1
<ct>
<name>group
<value>2 -->file2 (6 Replies)
Discussion started by: natalie23
6 Replies
4. Shell Programming and Scripting
Hi I have a very long file with 4 columns of numbers for example
1875 1876 12725 12723
13785 13786 4232 4230
13184 13185 ... (2 Replies)
Discussion started by: ananyob
2 Replies
5. Windows & DOS: Issues & Discussions
Hi
I want to print lines 20-30 from a file.
In UNIX , this command will work
sed -n '20,30p' file
However what is the equivalent command in DOS ?
Pls help me ! (2 Replies)
Discussion started by: dashing201
2 Replies
6. Shell Programming and Scripting
Hi all,
This should be very easy but I can't figure it out...
I have a file that looks like this:
@SRR057408.1 FW8Y5CK02R652T length=34
AGCAGTGGTATCAACGCAGAGTAAGCAGTGGTAT
+SRR057408.1 FW8Y5CK02R652T length=34
FIIHFF6666?=:88@@@BBD:::?@ABBAAA>8
@SRR057408.2 FW8Y5CK02TBMHV length=52... (1 Reply)
Discussion started by: kmkocot
1 Replies
7. Shell Programming and Scripting
Hi,
I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines).
#################################
huge_file.txt
a
a
ab
b
##################################
small_file.txt
a 1.5
b 2.5
ab ... (4 Replies)
Discussion started by: AshwaniSharma09
4 Replies
8. Shell Programming and Scripting
Hello everyone,
I have a little script below:
die "Usage infile outfile reGex" if @ARGV != 3;
($regex) = @ARGV;
open(F,$ARGV) or die "Can't open";
open(FOUT,"+>$ARGV") or die "Can't open";
while (<F>)
{
print FOUT if /$regex/.../$regex/;
}
No matter what I give $regex on the... (2 Replies)
Discussion started by: new bie
2 Replies
9. UNIX for Dummies Questions & Answers
Hello I am a new unix user, and I have a work related task to compare 2 files and print all of the lines in file 2 that contain a string from file 1 Note: the fields are in different columns in the files. I suspect the is a good use for awk? Thanks for your time & help
File 1
123 232 W343... (6 Replies)
Discussion started by: KevinRidley
6 Replies
10. Shell Programming and Scripting
Dear All,
a.txt
A 1 Z
A 1 ZZ
B 2 Y
B 2 AA
how can i use awk one line to achieve the result:
A Z|ZZ
B Y|AA
Thanks (5 Replies)
Discussion started by: jimmy_y
5 Replies
LEARN ABOUT CENTOS
drop_database
DROP
DATABASE(7) PostgreSQL 9.2.7 Documentation DROP DATABASE(7)
NAME
DROP_DATABASE - remove a database
SYNOPSIS
DROP DATABASE [ IF EXISTS ] name
DESCRIPTION
DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only
be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to
postgres or any other database to issue this command.)
DROP DATABASE cannot be undone. Use it with care!
PARAMETERS
IF EXISTS
Do not throw an error if the database does not exist. A notice is issued in this case.
name
The name of the database to remove.
NOTES
DROP DATABASE cannot be executed inside a transaction block.
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program dropdb(1)
instead, which is a wrapper around this command.
COMPATIBILITY
There is no DROP DATABASE statement in the SQL standard.
SEE ALSO
CREATE DATABASE (CREATE_DATABASE(7))
PostgreSQL 9.2.7 2014-02-17 DROP DATABASE(7)