Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk statement to eliminate the duplicates
Top Forums Shell Programming and Scripting awk statement to eliminate the duplicates Post 302585706 by birei on Thursday 29th of December 2011 05:51:01 AM
Old 12-29-2011
Hi vivek d r,

Some issues:
1.- Variable 'IGNORECASE' avoids to compare several strings with different case.
2.- Variable 'FS' splits line with any of those characters, so I added ')' to the whitespace char, and now only the function name is '$3', without parameters.
3.- I don't understand why you use awk inside echo. It can be done directly.

I would do this way:
Code:
$ awk 'BEGIN { IGNORECASE = 1; FS = "[( ]" } {if($3~v){a=1}}a;/delimiter/{exit}' v="$proc_name1" tablextract2.sql
CREATE PROCEDURE after72DeleteTgr(id int)
BEGIN
END
$$
Delimiter ;

Regards,
Birei
This User Gave Thanks to birei For This Post:
vivek d r
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to eliminate inf value in AWK

Hi, I have the calculations which return me infinity (inf), -inf, other very larger number when I printed them out. I did try to insert some control condition not to print these out if the above condition is met. The code I implemented is something like:- for (i=0;i<=1000;i++){ ... (3 Replies)
Discussion started by: ahjiefreak
3 Replies

2. Shell Programming and Scripting

Awk to find duplicates in 2nd field

I want to find duplicates in file on 2nd field i wrote this code: nawk '{a++} END{for i in a {if (a>1) print}}' temp Could not find whats wrong with this. Appreciate help (5 Replies)
Discussion started by: pinnacle
5 Replies

3. Shell Programming and Scripting

Awk Help - duplicates in $1 that match x & y in $2

I'm primarily a "Windows" systems administrator whose been getting his toes in the Linux waters. I am new to programming and advanced scripting so please bear with me and my incomplete example below. I have exported all entries from our DNS zones. I used sed to remove everything other than the... (3 Replies)
Discussion started by: Omaplata
3 Replies

4. Shell Programming and Scripting

Find duplicates in column 1 and merge their lines (awk?)

Hi, I have a file (sorted by sort) with 8 tab delimited columns. The first column contains duplicated fields and I need to merge all these identical lines. My input file: comp100002 aaa bbb ccc ddd eee fff ggg comp100003 aba aba aba aba aba aba aba comp100003 fff fff fff fff fff fff fff... (5 Replies)
Discussion started by: falcox
5 Replies

5. Shell Programming and Scripting

Creating duplicates in awk

Hi, I am using Ubuntu 12.04 I have a file as following: KHO123 KHO245 KHO456 . . .I want to add a second column of characters to my file but I want to write a script to make this automatic, so, depending on the number of the lines in my first column, I get the string I need repeated... (4 Replies)
Discussion started by: Homa
4 Replies

6. Shell Programming and Scripting

Awk: Remove Duplicates

I have the following code for removing duplicate records based on fields in inputfile file & moves the duplicate records in duplicates file(1st Awk) & in 2nd awk i fetch the non duplicate entries in inputfile to tmp file and use move to update the original file. Requirement: Can both the awk... (4 Replies)
Discussion started by: siramitsharma
4 Replies

7. Shell Programming and Scripting

awk remove first duplicates

Hi All, I have searched many threads for possible close solution. But I was unable to get simlar scenario. I would like to print all duplicate based on 3rd column except the first occurance. Also would like to print if it is single entry(non-duplicate). i/P file 12 NIL ABD LON 11 NIL ABC... (6 Replies)
Discussion started by: sybadm
6 Replies

8. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies

9. Shell Programming and Scripting

awk - Remove duplicates during array build

Greetings Experts, Issue: Within awk script, remove the duplicate occurrences that are space (1 single space character) separated Description: I am processing 2 files using awk and during processing, I am building an array and there are duplicates on this; how can I delete the duplicates... (3 Replies)
Discussion started by: chill3chee
3 Replies

10. Shell Programming and Scripting

awk and seen to report duplicates

I have this file: @Muestra-1 agctgcgagctgcgacccgggttatataggaagagacacacacaccccc + !@$#%^&*()@^#&HH!&*(@&#*(FT^%$&*()*&^%@ @Muestra-2 agctgcgagctgcgacccgggttatataggaagagacacacacaccccc + !@$#%^&*()@^#&HH!&*(@&#*(FT^%$&*()*&^%@ @Muestra-3 agctgcgagctgcgacccgggttatataggaagagacacacacaccccc +... (4 Replies)
Discussion started by: Xterra
4 Replies

LEARN ABOUT SUSE

deleg_proc

deleg_proc(n)						       Interpreter utilities						     deleg_proc(n)

__________________________________________________________________________________________________________________________________________________

NAME

       deleg_proc - Creation of comm delegates (procedures)

SYNOPSIS

       package require Tcl  8.3

       package require interp::delegate::proc  ?0.2?

       ::interp::delegate::proc ?-async? name arguments comm id

_________________________________________________________________

DESCRIPTION

       This  package provides a single command for the convenient creation of procedures which delegate the actual work to a remote location via a
       "channel" created by the package comm.

API

       ::interp::delegate::proc ?-async? name arguments comm id
	      This commands creates a procedure which is named by name and returns its fully-qualified name. All  invokations  of  this  procedure
	      will delegate the actual work to the remote location identified by the comm channel comm and the endpoint id.

	      The name of the remote procedure invoked by the delegator is [namespace tail name]. I.e., namespace information is stripped from the
	      call.

	      Normally the generated procedure marshalls the arguments, and returns the result from the remote procedure as  its  own  result.	If
	      however the option -async was specified then the generated procedure will not wait for a result and return immediately.

BUGS, IDEAS, FEEDBACK
       This  document,	and the package it describes, will undoubtedly contain bugs and other problems.  Please report such in the category interp
       of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you may have for
       either package and/or documentation.

KEYWORDS

       comm, delegation, interpreter, procedure

COPYRIGHT

       Copyright (c) 2006 Andreas Kupries <andreas_kupries@users.sourceforge.net>

interp									0.2							     deleg_proc(n)
All times are GMT -4. The time now is 07:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy