10-16-2005
global replace...
Hi,
I have a dir containing many shell scripts. Each of these shell scripts state a database name (always the same), which I need to change to be a new database.
grep <database name> * brings back all the lines containing the database name. However, I need to change them to be something else.
Is there an easy way around this? or is it better to create a new dir area and use sed somehow?
Very new to all this? Can't find simple answer to match the simple query....
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Gurus,
I have in my /tmp directory 26 files "filea", "fileb"..."filez". Each file contains the name of a database 'dwora' at many, many places within each file.
My boss decided to change the name of the db so I need to do (what i'd call) a global search&replace of that string in all my... (0 Replies)
Discussion started by: alan
0 Replies
2. Shell Programming and Scripting
I have a file where the rows correspond to individuals and the columns are about 106 variables. Each variable is coded as either ACGT, and "missing" is coded as blank. This is a tab delimited file. I'm trying to replace all blanks (" ") with 0. The simple script I have is only replacing some of the... (3 Replies)
Discussion started by: epi8
3 Replies
3. Shell Programming and Scripting
Hi,
I need to change some strings from A to B in a number of files within a directory. Please can someone advise how do I do that?
Many thanks (5 Replies)
Discussion started by: canary
5 Replies
4. Shell Programming and Scripting
I am new to unix and awk/sed etc... using C-Shell.
Basically, I have a fixed length file that has 4 different record types on it, H, D, V, W all in column 1. I need to change all the W's in column 1 to D's. in the entire file. The W's can be anywhere in the file and must remain in the same... (3 Replies)
Discussion started by: jclanc8
3 Replies
5. Shell Programming and Scripting
Hi all
I'm in need of a command which can replace a specified string with another string - across multiple files within multiple sub-directories (I intend to run it from / )
I've used the following to get a list of the files:
find . | xargs grep <string1>
But that's as far as I've got.... (7 Replies)
Discussion started by: huskie69
7 Replies
6. Shell Programming and Scripting
Hi all,
I want to replace a string of words but i dont want to worry about escaping the characters in that string .
For e.g. If my string is "work/" and i want to replace it with "nowork" .I have to type
%s/work\//nowork/g
Is there a way by which I wont need to worry about the data in... (1 Reply)
Discussion started by: sachinpawar2308
1 Replies
7. Shell Programming and Scripting
Hello
I need to search for a mult-line strngs(with spaces in between and qoted) in a file1 and replace that text with Fixed string globally in file1. The strng to search for is in file2.
The file is big with some 20K records. so speed and effciency is required
file1: (where srch & rplc... (0 Replies)
Discussion started by: Hiano
0 Replies
8. UNIX for Dummies Questions & Answers
I am wondering what way, I can remove a certain text with nothing.
for example:
MyVariable=Y7UHNI
to only:
Y7UHNI
removing 'MyVariable=' globally?
thanks (1 Reply)
Discussion started by: DallasT
1 Replies
9. Shell Programming and Scripting
I am newbie to perl,
I am trying to use the below syntax to replace globally a string with a variable.
$ bash -version
GNU bash, version 2.05b.0(1)-release (powerpc-ibm-aix5.1)
Copyright (C) 2002 Free Software Foundation, Inc.
$ perl -version
This is perl, v5.8.8 built for... (2 Replies)
Discussion started by: jville
2 Replies
10. UNIX for Dummies Questions & Answers
Hello -
I am trying to use a global replace command but its not working.
Here is the cmd I am using in vi:
:%s/OLD/NEW/g
However, in my "NEW" I already have a "/" which is not making the replace work:
:%s/mytestscript.com:33232/mytestscript:70245/test.com/g
the... (2 Replies)
Discussion started by: DallasT
2 Replies
LEARN ABOUT REDHAT
drop_database
DROP
DATABASE(7) SQL Commands DROP DATABASE(7)
NAME
DROP DATABASE - remove a database
SYNOPSIS
DROP DATABASE name
INPUTS
name The name of an existing database to remove.
OUTPUTS
DROP DATABASE
This message is returned if the command is successful.
DROP DATABASE: cannot be executed on the currently open database
You cannot be connected to the database you are about to remove. Instead, connect to template1 or any other database and run this
command again.
DROP DATABASE: may not be called in a transaction block
You must finish the transaction in progress before you can call this command.
DESCRIPTION
DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data. It can only be executed
by the database owner (usually the user that created it).
DROP DATABASE cannot be undone. Use it with care!
NOTES
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
[dropdb(1)], which is a wrapper around this command, instead.
Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.
COMPATIBILITY
SQL92
DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.
SQL - Language Statements 2002-11-22 DROP DATABASE(7)