Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Search and replace words between two keywords
Top Forums Shell Programming and Scripting Search and replace words between two keywords Post 71191 by vrrajeeb on Sunday 8th of May 2005 11:54:09 AM
Old 05-08-2005
Search and replace words between two keywords
Hi,

I have a file which contains the following :

select * from test where test_id=1;

select id
from test1, test2 where test_id=1 and test_id=2;

select * from
test1, test2, test3 where test_id=4 and test2_id where in (select test2_id from test2);

select
id1, id2 from test
where test_id=1;

............................

I need all words between first "from" (including) and first "where" condition (excluding) to be deleted irrespective of whether they span on multiple lines ...

ie., the required output is :

select * where test_id=1;
select id where test_id=1 and test_id=2;
select * where test_id=4 and test2_id=6 where in (select test2_id from test2);
select id1, id2 where test_id=1;


Thanx

-RR
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to search for keywords in subsequent lines

Hi all, I am looking for a coomand to search for the keywords in susequenct lines. Keyword1 in a line and Keyword2 in the very next line. Once i found the combination ineed to print the lines with patterns and the line above and one below. I am giving an example here: Keywords are :ERROR and... (12 Replies)
Discussion started by: rdhanek
12 Replies

2. Shell Programming and Scripting

Search a file with keywords

Hi All I have a file of format asdf asf first sec endi asdk rt 123 ferf dfg ijglkp (7 Replies)
Discussion started by: mailabdulbari
7 Replies

3. Shell Programming and Scripting

search and replace combination of two words...with a constraint

Hi I have 100 files in my directory. Please help me how to do in Unix or any other scriptin lanuages. I want to replace all occurances of "goutham" to goutham_ind ONLY if the file contains the word "goutham" with the word "engineer"; for eg----test1 is a file contains the following inf; goutham... (6 Replies)
Discussion started by: nandugo1
6 Replies

4. Shell Programming and Scripting

Shell script to find out words, replace them and count words

hello, i 'd like your help about a bash script which: 1. finds inside the html file (it is attached with my post) the code number of the Latest Stable Kernel, 2.finds the link which leads to the download location of the Latest Stable Kernel version, (the right link should lead to the file... (3 Replies)
Discussion started by: alex83
3 Replies

5. Shell Programming and Scripting

Perl - use search keywords from array and search a file and print 3rd field when matched

Hi , I have been trying to write a perl script to do this job. But i am not able to achieve the desired result. Below is my code. my $current_value=12345; my @users=("bob","ben","tom","harry"); open DBLIST,"<","/var/tmp/DBinfo"; my @input = <DBLIST>; foreach (@users) { my... (11 Replies)
Discussion started by: chidori
11 Replies

6. Shell Programming and Scripting

Extracting words and lines based on keywords

Hello! I'm trying to process a text file and am stuck at 2 extractions. Hoping someone can help me here: 1. Given a line in a text file and given a keyword, how can I extract the word preceeding the keyword using a shell command/script? For example: Given a keyword "world" in the line: ... (2 Replies)
Discussion started by: seemad
2 Replies

7. UNIX for Dummies Questions & Answers

Replace the words in the file to the words that user type?

Hello, I would like to change my setting in a file to the setting that user input. For example, by default it is ONBOOT=ON When user key in "YES", it would be ONBOOT=YES -------------- This code only adds in the entire user input, but didn't replace it. How do i go about... (5 Replies)
Discussion started by: malfolozy
5 Replies

8. Shell Programming and Scripting

Search words in any quote position and then change the words

hi, i need to replace all words in any quote position and then need to change the words inside the file thousand of raw. textfile data : "Ninguno","Confirma","JuicioABC" "JuicioCOMP","Recurso","JuicioABC" "JuicioDELL","Nulidad","Nosino" "Solidade","JuicioEUR","Segundo" need... (1 Reply)
Discussion started by: benjietambling
1 Replies

9. Shell Programming and Scripting

Replace particular words in file based on if finds another words in that line

Hi All, I need one help to replace particular words in file based on if finds another words in that file . i.e. my self is peter@king. i am staying at north sydney. we all are peter@king. How to replace peter to sham if it finds @king in any line of that file. Please help me... (8 Replies)
Discussion started by: Rajib Podder
8 Replies

LEARN ABOUT DEBIAN

ecaccess-file-move

ECACCESS-FILE-MOVE(1p)					User Contributed Perl Documentation				    ECACCESS-FILE-MOVE(1p)

NAME

       ecaccess-file-move - Move or Rename ECaccess Files

SYNOPSIS

       ecaccess-file-move -version|-help|-manual

       ecaccess-file-move [-debug] source-ecaccess-file target-ecaccess-file

DESCRIPTION

       Allow moving an ECaccess File. When the move occurs within the same ECaccess File System then it is a rename. When the move occurs across
       two different ECaccess File Systems then first a copy is done and then a delete of the original file is done (e.g. similar to ecaccess-
       file-copy ... -erase).

       The source-ecaccess-file and target-ecaccess-file are in the form [domain:][/user-id/]path. Please read the "Shell commands -> File
       Management" section of the "ecaccess" guide for more information on the ECaccess File System.

ARGUMENTS

       source-ecaccess-file
	       The source ECaccess File name.

       target-ecaccess-file
	       The target ECaccess File name.

OPTIONS

       -version
	       Display version number and exits.

       -help   Print a brief help message and exits.

       -manual Prints the manual page and exits.

       -debug  Display the SOAP messages exchanged.

EXAMPLES

       ecaccess-file-move ec:test1.txt ec:test2.txt

       Rename the test1.txt file in the ECFS directory of the authenticated user in test2.txt.

       ecaccess-file-move ec:test1.txt home:test2.txt

       Copy the test1.txt file from the ECFS directory of the authenticated user to the test2.txt file in the $HOME directory of the authenticated
       user, then delete the test1.txt file from ECFS.

SEE ALSO

       ecaccess-file-delete, ecaccess-file-get, ecaccess-file-mget, ecaccess-file-modtime, ecaccess-file-mput, ecaccess-file-rmdir, ecaccess-file-
       copy, ecaccess-file-dir, ecaccess-file-mdelete, ecaccess-file-mkdir, ecaccess-file-chmod, ecaccess-file-put, ecaccess-file-size and
       ecaccess.

perl v5.14.2							    2012-04-16						    ECACCESS-FILE-MOVE(1p)
All times are GMT -4. The time now is 02:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy