Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: matching pattern and replacement
Operating Systems Linux matching pattern and replacement Post 302200661 by capri_drm on Thursday 29th of May 2008 06:34:17 PM
Old 05-29-2008
Well , I modified it to better one ( I guess ) but I don't get the output file as desired one .

The updated code is

cat dim_provider.sql | grep -i "create view" | while read f1 f2 f3 f4 f5 f6 f7 f8 f9
do
new_vw=` echo "$f3" | cut -d "." -f2 `
echo "${new_vw}"
cat dim_provider.sql | grep -i GRANT | grep -i ${new_vw} | while read f1 f2 f3 f4 f5 f6 f7 f8 f9
do
sed -e s/${new_vw}/VW_${new_vw}/g dim_provider.sql > dim_provider.sql1
done
done

and sh -x of shl is

#sh -x add_VW_grants.shl
+ [[ -n 1 ]]
+ return
+ cat dim_provider.sql
+ grep -i create view
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ + echo OPSDM002.PROVIDER_MBR_PRI
+ cut -d . -f2
new_vw=PROVIDER_MBR_PRI
+ echo PROVIDER_MBR_PRI
PROVIDER_MBR_PRI
+ cat dim_provider.sql
+ grep -i GRANT
+ grep -i PROVIDER_MBR_PRI
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_MBR_PRI/VW_PROVIDER_MBR_PRI/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_MBR_PRI/VW_PROVIDER_MBR_PRI/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_MBR_PRI/VW_PROVIDER_MBR_PRI/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_MBR_PRI/VW_PROVIDER_MBR_PRI/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ + echo OPSDM002.PROVIDER_REF
+ cut -d . -f2
new_vw=PROVIDER_REF
+ echo PROVIDER_REF
PROVIDER_REF
+ cat dim_provider.sql
+ grep -i GRANT
+ grep -i PROVIDER_REF
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_REF/VW_PROVIDER_REF/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_REF/VW_PROVIDER_REF/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_REF/VW_PROVIDER_REF/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_REF/VW_PROVIDER_REF/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ + echo OPSDM002.PROVIDER_SRVC
+ cut -d . -f2
new_vw=PROVIDER_SRVC
+ echo PROVIDER_SRVC
PROVIDER_SRVC
+ cat dim_provider.sql
+ grep -i GRANT
+ grep -i PROVIDER_SRVC
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_SRVC/VW_PROVIDER_SRVC/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_SRVC/VW_PROVIDER_SRVC/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_SRVC/VW_PROVIDER_SRVC/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_SRVC/VW_PROVIDER_SRVC/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
apsp8642:/dba_wk/dual_schema #

Any help is appreciated !
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pattern Replacement

There is a requirement that i need to replaced a pattern by another pattern in all the files in my entire file system. there are 1000s of file in the system. let the pattern is "calcuta". i have to replace this pattern by "kolkata" in all those files which contain "calcuta". I am only able to... (12 Replies)
Discussion started by: palash2k
12 Replies

2. Shell Programming and Scripting

comment/delete a particular pattern starting from second line of the matching pattern

Hi, I have file 1.txt with following entries as shown: 0152364|134444|10.20.30.40|015236433 0233654|122555|10.20.30.50|023365433 ** ** ** In file 2.txt I have the following entries as shown: 0152364|134444|10.20.30.40|015236433 0233654|122555|10.20.30.50|023365433... (4 Replies)
Discussion started by: imas
4 Replies

3. Shell Programming and Scripting

counting the lines matching a pattern, in between two pattern, and generate a tab

Hi all, I'm looking for some help. I have a file (very long) that is organized like below: >Cluster 0 0 283nt, >01_FRYJ6ZM12HMXZS... at +/99% 1 279nt, >01_FRYJ6ZM12HN12A... at +/99% 2 281nt, >01_FRYJ6ZM12HM4TS... at +/99% 3 283nt, >01_FRYJ6ZM12HM946... at +/99% 4 279nt,... (4 Replies)
Discussion started by: d.chauliac
4 Replies

4. UNIX for Dummies Questions & Answers

awk pattern replacement

Hi I'm a newbie in unix and I'm having trouble in creating a script. I want to search for a pattern '_good' and insert new lines that contains '_bad', '_med', '_fail' while also ensure that the line contains _good is removed here some of the data UPDATE SCHOOL SET GRADE =... (1 Reply)
Discussion started by: sexyTrojan
1 Replies

5. Shell Programming and Scripting

Sed for selective pattern replacement

Hi I am having a code snippet grant permission to all user sts|ln|uSe|PSG sajncht|se|Use|PPSPSG psg|ln|use|TSPSG sts_user.Me revoke I need to change all occurance of use (uSe,Use,use) with USE. I am using the following sed command for this sed 's//USE/g' s_sample.txt Output: (7 Replies)
Discussion started by: sudeep.id
7 Replies

6. Shell Programming and Scripting

Sed: printing lines AFTER pattern matching EXCLUDING the line containing the pattern

'Hi I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match. Which option is to be used to exclude the line containing the pattern? sed -n '/Conn.*User/,$p' > consumers.txt (11 Replies)
Discussion started by: essem
11 Replies

7. Shell Programming and Scripting

PHP - Regex for matching string containing pattern but without pattern itself

The sample file: dept1: user1,user2,user3 dept2: user4,user5,user6 dept3: user7,user8,user9 I want to match by '/^dept2.*/' but don't want to have substring 'dept2:' in output. How to compose such regex? (8 Replies)
Discussion started by: urello
8 Replies

8. Shell Programming and Scripting

Pattern Matching and replacement

Hello Everybody, I need a help in the below pattern matching and replacement issue I have a file : emp.txt 21356 suresh 12/12/2012 23511 ramesh 11/06/2011 31456 biswajit 09/08/2013 53134 archan 06/02/2009 first field:- employee id, 2nd field is name and third field is date of joining ... (10 Replies)
Discussion started by: shellscripting
10 Replies

9. Shell Programming and Scripting

Help with Pattern Matching and replacement in Gz files

Hi Techies, I need a help in finding junk characters and remove them from a Datafile. we have a file and it had crores of records like below SGSN_MCC_MNC=01150 but sometime due to the issue with sending server we are getting some junk characters in the middle of data like below ... (6 Replies)
Discussion started by: mahi_mayu069
6 Replies

10. UNIX for Dummies Questions & Answers

Grep -v lines starting with pattern 1 and not matching pattern 2

Hi all! Thanks for taking the time to view this! I want to grep out all lines of a file that starts with pattern 1 but also does not match with the second pattern. Example: Drink a soda Eat a banana Eat multiple bananas Drink an apple juice Eat an apple Eat multiple apples I... (8 Replies)
Discussion started by: demmel
8 Replies

LEARN ABOUT PHP

mysql_create_db

MYSQL_CREATE_DB(3)							 1							MYSQL_CREATE_DB(3)

mysql_create_db - Create a MySQL database

SYNOPSIS

       Warning

	      This  function  was deprecated in PHP 4.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
	      sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide  and  related  FAQ  for  more
	      information. Alternatives to this function include:

		     omysqli_query(3)

		     o PDO::query

       bool mysql_create_db (string  $database_name, [resource	$link_identifier = NULL])

DESCRIPTION

       mysql_create_db(3) attempts to create a new database on the server associated with the specified link identifier.

	      o $database_name
		- The name of the database being created.

	      o $
		link_identifier  -The  MySQL  connection.  If  the  link  identifier is not specified, the last link opened by mysql_connect(3) is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	Returns TRUE on success or FALSE on failure.

       Example #1

	      mysql_create_db(3) alternative example

	       The  function  mysql_create_db(3)  is  deprecated. It is preferable to use mysql_query(3) to issue an sql CREATE DATABASE statement
	      instead.

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }

	      $sql = 'CREATE DATABASE my_db';
	      if (mysql_query($sql, $link)) {
		  echo "Database my_db created successfully
";
	      } else {
		  echo 'Error creating database: ' . mysql_error() . "
";
	      }
	      ?>

	      The above example will output something similar to:

	      Database my_db created successfully

       Note

	       For backward compatibility, the following deprecated alias may be used: mysql_createdb(3)

       Note

	       This function will not be available if the MySQL extension was built against a MySQL 4.x client library.

       mysql_query(3), mysql_select_db(3).

PHP Documentation Group 													MYSQL_CREATE_DB(3)
All times are GMT -4. The time now is 01:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy