Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk statement to eliminate the duplicates

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk statement to eliminate the duplicates
# 1  
Old 12-29-2011
awk statement to eliminate the duplicates
consider the below output

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 ;

this is because $3 will be looking for "after72DeleteTgr" and not after72DeleteTgr(...) as the startpoint... is there anyway to solve this... i mean i need only one procedure in the file than two
# 2  
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
# 3  
Old 12-29-2011
thanks a lot your code worked :-)
Code:
awk 'BEGIN { IGNORECASE = 1; FS = "[( ]" } {if($3~v){a=1}}a;/delimiter/{exit}' v="$proc_name1" tablextract2.sql

one last doubt you have used ignore case so will this satisfy if the endpoint is either DELIMITER or Delimiter..? ignorecase should work only for delimiter and not proc_name1...
# 4  
Old 12-29-2011
A idiom perl:
Code:
 perl -lne '$print=1 if /'${proc_name1}'/;print unless !$print;/Delimiter/i && exit ' infile

This User Gave Thanks to Klashxx For This Post:
vivek d r
# 5  
Old 12-29-2011
Quote:
Originally Posted by vivek d r
thanks a lot your code worked :-)
Code:
awk 'BEGIN { IGNORECASE = 1; FS = "[( ]" } {if($3~v){a=1}}a;/delimiter/{exit}' v="$proc_name1" tablextract2.sql

one last doubt you have used ignore case so will this satisfy if the endpoint is either DELIMITER or Delimiter..? ignorecase should work only for delimiter and not proc_name1...
Yes. IGNORECASE has effect over all string comparisons, so maybe is not what you need. Yo can leave it as you had it or use 'tolower()' function, like:
Code:
$ awk 'BEGIN { FS = "[( ]" } {if($3~v){a=1}}a;tolower($0) ~ /delimiter/{exit}' v="$proc_name1" tablextract2.sql

This way, '$3~v' will be compared with case but in '/delimiter/' will be irrelevant.

Regards,
Birei
This User Gave Thanks to birei For This Post:
vivek d r
# 6  
Old 12-29-2011
@klashxx: is there any way to redirect the output to same file....?
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]# echo "`perl -lne '$print=1 if /'${proc_name1}'/;print unless !$print;/Delimiter/i && exit ' tablextract2.sql`" > tablextract2.sql
echo "`perl -lne '$print=1 if /'${proc_name1}'/;print unless tablextract2.sqlprint;/Delimiter/i && exit ' tablextract2.sql`" > tablextract2.sql
[root@dunkin-ds-dev-103 vivek]# cat tablextract2.sql

Code:
perl -lne '$print=1 if /'${proc_name1}'/;print unless !$print;/Delimiter/i && exit ' tablextract2.sql
CREATE PROCEDURE after72DeleteTgr(id int)
BEGIN
END
$$
Delimiter ;

i need to overwrite same file having only one procedure....

---------- Post updated at 07:03 PM ---------- Previous update was at 06:58 PM ----------

thanks Birei.. your code works good.. thanks a lot :-)
# 7  
Old 12-29-2011
Code:
 perl -in -e '$print=1 if /'${proc_name1}'/;print unless !$print;/Delimiter/i && exit ' tablextract2.sql
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question