Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Making case insensitive in awk
Top Forums Shell Programming and Scripting Making case insensitive in awk Post 302585612 by vivek d r on Thursday 29th of December 2011 03:47:53 AM
Old 12-29-2011
Code:
cat tablextract2.sql
CREATE PROCEDURE after72DeleteTgr(id int)
BEGIN
END
$$
Delimiter ;
CREATE PROCEDURE after72DeleteTgr(id int)
BEGIN
END
$$
Delimiter ;
[root@dunkin-ds-dev-103 vivek]#
[root@dunkin-ds-dev-103 vivek]# proc_name1="after72DeleteTgr"
[root@dunkin-ds-dev-103 vivek]#
[root@dunkin-ds-dev-103 vivek]#  echo "`awk '{if($3~v){a=1}}a;/[dD]elimiter\|DELIMITER/{exit}' v="$proc_name1" tablextract2.sql`" > tablextract2.sql
[root@dunkin-ds-dev-103 vivek]# cat tablextract2.sql
CREATE PROCEDURE after72DeleteTgr(id int)
BEGIN
END
$$
Delimiter ;
CREATE PROCEDURE after72DeleteTgr(id int)
BEGIN
END
$$
Delimiter ;

is this because $3 will be looking for "after72DeleteTgr" and not after72DeleteTgr(...) as the startpoint....?

---------- Post updated at 02:17 PM ---------- Previous update was at 12:06 PM ----------

........
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Case-insensitive serach with awk

Is there any way to do case insensitive search with awk for the below statement: month1=`awk '/month/' ${trgfile} | cut -d"=" -f2` the "month" could come as Month, mOnth,MONTH etc. in a file. Now I am looking for "month".... Thanks, AC (4 Replies)
Discussion started by: acheepi
4 Replies

2. Shell Programming and Scripting

awk case-insensitive

can I tell awk to be case insensitive for one operation without setting the ignorecase value ? thanks, Steffen (7 Replies)
Discussion started by: forever_49ers
7 Replies

3. Shell Programming and Scripting

case-insensitive search with AWK

Hi All, How we can perform case-insensitive search with AWK.:rolleyes: regards, Sam (11 Replies)
Discussion started by: sam25
11 Replies

4. Shell Programming and Scripting

Making expr match case insensitive...

here is the condition i am using ] how to make this case insesntive... that is it should work with smaller case of "index" too... (11 Replies)
Discussion started by: vivek d r
11 Replies

5. Shell Programming and Scripting

Making case insensitive perl statement

cat > tble blah blah blah sdfsdf dsdf sdf .d.f ..df .. sdf.. create table NextID ( id int auto_increment, zoneID int, entityName varchar(64), nextID int, lastModified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, primary... (6 Replies)
Discussion started by: vivek d r
6 Replies

6. Shell Programming and Scripting

making sed command case insensitive

i have something like this in a file cat onlytables.sql create table NextID ( id int auto_increment, zoneID int, entityName varchar(64), nextID int, lastModified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, primary... (6 Replies)
Discussion started by: vivek d r
6 Replies

7. Shell Programming and Scripting

Use case insensitive variable in ksh shell scripting using sed or awk

I am using a variable called $variable in a pattern search to print from a starting variable to a constant value. the variable search should be case in sensitive. i tired using Ip at the end in the below command. but in ksh it is not working. sed -n "/$variable/,/constant/p" file i also... (11 Replies)
Discussion started by: johnjs
11 Replies

8. Shell Programming and Scripting

Output piped to case insensitive awk

I have an encrypted password file, and I've created a simple script to search the password file for a particular record. There are multiple lines per record, so I'm using a record delimiter. #!/bin/bash PATTERN=$1 openssl des3 -d -salt -in ~/docs/pass.des3 | awk '{ FS="\n" ; RS="*" }... (2 Replies)
Discussion started by: 0rac1e
2 Replies

9. UNIX for Beginners Questions & Answers

Making SED case insensitive

Dears, In the below string, please let me know how to make the sed search case-incensitive. I have more such lines in my script instead of let me know any other easier option. sed -n '/dn: MSISDN=/,/^\s*$/p' full.ldif > temp ; sed -n... (4 Replies)
Discussion started by: Kamesh G
4 Replies

10. UNIX for Beginners Questions & Answers

Using awk to search case insensitive

Hello , Using the below scrip to search a string in a file , by case-insensitively Please assist on using the toupper() as getting error !. #!/usr/bin/ksh set -x curr_dir=`pwd` file_ctr=0 printf "\n Reviewing the output file from the directory: %s \n\n" $curr_dir ls -latr ... (4 Replies)
Discussion started by: Siva SQL
4 Replies

LEARN ABOUT CENTOS

do

DO(7)							  PostgreSQL 9.2.7 Documentation						     DO(7)

NAME

       DO - execute an anonymous code block

SYNOPSIS

       DO [ LANGUAGE lang_name ] code

DESCRIPTION

       DO executes an anonymous code block, or in other words a transient anonymous function in a procedural language.

       The code block is treated as though it were the body of a function with no parameters, returning void. It is parsed and executed a single
       time.

       The optional LANGUAGE clause can be written either before or after the code block.

PARAMETERS

       code
	   The procedural language code to be executed. This must be specified as a string literal, just as in CREATE FUNCTION. Use of a
	   dollar-quoted literal is recommended.

       lang_name
	   The name of the procedural language the code is written in. If omitted, the default is plpgsql.

NOTES

       The procedural language to be used must already have been installed into the current database by means of CREATE LANGUAGE.  plpgsql is
       installed by default, but other languages are not.

       The user must have USAGE privilege for the procedural language, or must be a superuser if the language is untrusted. This is the same
       privilege requirement as for creating a function in the language.

EXAMPLES

       Grant all privileges on all views in schema public to role webuser:

	   DO $$DECLARE r record;
	   BEGIN
	       FOR r IN SELECT table_schema, table_name FROM information_schema.tables
			WHERE table_type = 'VIEW' AND table_schema = 'public'
	       LOOP
		   EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser';
	       END LOOP;
	   END$$;

COMPATIBILITY

       There is no DO statement in the SQL standard.

SEE ALSO

       CREATE LANGUAGE (CREATE_LANGUAGE(7))

PostgreSQL 9.2.7						    2014-02-17								     DO(7)
All times are GMT -4. The time now is 08:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy