Exact match using sed Post: 302886486

Sponsored Content

Top Forums Shell Programming and Scripting Exact match using sed Post 302886486 by Don Cragun on Friday 31st of January 2014 11:22:56 PM

02-01-2014

Registered User

In your sample input, the value you're looking for only appears in the last field.

Here are a couple of awk scripts. The first script only looks for the desired value in the last field of each input line; the second script looks for the desired value in any filed:

Code:

#!/bin/ksh
search_value=${1:-21}
echo 'Checking last field only:'
awk -v sv="$search_value" '$NF != sv' file
printf '\nChecking every field:\n'
awk -v sv="$search_value" '
{       for(i = 1; i <= NF; i++)
                if($i == sv)
                        next
        print
}' file

If you want to try this on a Solaris/SunOS System, use /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk instead of the default /usr/bin/awk. This script was tested using a Korn shell, but will also work with any other shell that recognizes basic POSIX shell syntax (such as bash).

If you make the above script an executable file named tester and the file named file contains your sample input:

Code:

543 1 2 5 21
5421 5 9 2
678 7 8 10
78921 9 10 11 21
78 0 23 2 4
9821 3 4 2 21
8943 7 8 10

the output produced by executing either of the commands:

Code:

./tester
    or
./tester 21

will be:

Code:

Checking last field only:
5421 5 9 2
678 7 8 10
78 0 23 2 4
8943 7 8 10

Checking every field:
5421 5 9 2
678 7 8 10
78 0 23 2 4
8943 7 8 10

and the command:

Code:

./tester 2

will produce the output:

Code:

Checking last field only:
543 1 2 5 21
678 7 8 10
78921 9 10 11 21
78 0 23 2 4
9821 3 4 2 21
8943 7 8 10

Checking every field:
678 7 8 10
78921 9 10 11 21
8943 7 8 10

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

using sed or grep to find exact match of text

Hi, Can anyone help me with the text editing I need here. I have a file that contains the following lines for example: (line numbers are for illustration only) 1 Hello world fantasy. 2 Hello worldfuntastic. 3 Hello world wonderful. I would like to get all those lines of text that...

2. Shell Programming and Scripting

sed to match only exact string only in all occurences

Dear Friends, Anybody knows how to match exact lines only in multilinear. Input file: apple orange orange apple apple orange Desired output: fruit orange apple fruit i used the command

3. Shell Programming and Scripting

exact string match ; search and print match

I am trying to match a pattern exactly in a shell script. I have tried two methods awk '/\<mpath${CURR_MP}\>/{print $1 $2}' multipath perl -ne '/\bmpath${CURR_MP}\b/ and print' /var/tmp/multipath Both these methods require that I use the escape character. I am guessing that is why...

4. Shell Programming and Scripting

SED to replace exact match, not first occurrence.

Lets say I have file.txt: (Product:Price:QuantityAvailable) (: as delimiter) Chocolate:5:5 Banana:33:3 I am doing a edit/update function. I want to change the Quantity Available, so I tried using the SED command to replace 5, but my Price which is also 5 is changed instead. (for the Banana...

5. UNIX for Dummies Questions & Answers

grep and sed exact match questions

This was mistaken as homework in a different forum, but is not. These are questions that are close to what I am trying to do at work. QUESTION1: How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed. Contents of car.txt CAR1_KEY0 CAR1_KEY1...

6. Shell Programming and Scripting

grep and sed exact match questions

This post was previously mistaken for homework, but is actually a small piece of what I working on at work. Please answer if you can. QUESTION1 How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed. Contents of car.txt CAR1_KEY0 CAR1_KEY1...

7. Shell Programming and Scripting

Grep or sed - printing line only with exact match

8. UNIX for Dummies Questions & Answers

sed Exact Match when Dot is present

I am trying to replace exact word from my text. I know using the angled brackets does the trick. But it is not working when there is a dot in the text. echo "Bottle BottleWater Bottle Can" | sed 's/\<Bottle\>//g' BottleWater CanBut if my data has a dot or hash in it, it replaces all the...

9. Shell Programming and Scripting

Match exact String with sed command

I have a workaround to the problem i m posting, however if someone wants to look at my query and respond ... i will appreciate. This is in reference to this thread -> https://www.unix.com/shell-programming-and-scripting/267630-extract-between-two-exact-matched-strings.html I have data.txt as...

10. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt...

LEARN ABOUT SUSE

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

Free Software Foundation					    Nov 3 1999								  IGAWK(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

using sed or grep to find exact match of text

Discussion started by: risk_sly

2. Shell Programming and Scripting

sed to match only exact string only in all occurences

Discussion started by: vasanth.vadalur

3. Shell Programming and Scripting

exact string match ; search and print match

Discussion started by: bash_in_my_head

4. Shell Programming and Scripting

SED to replace exact match, not first occurrence.

Discussion started by: andylbh

5. UNIX for Dummies Questions & Answers

grep and sed exact match questions

Discussion started by: thibodc

6. Shell Programming and Scripting

grep and sed exact match questions

Discussion started by: thibodc

7. Shell Programming and Scripting

Grep or sed - printing line only with exact match

Discussion started by: jcdole

8. UNIX for Dummies Questions & Answers

sed Exact Match when Dot is present

Discussion started by: grep_me

9. Shell Programming and Scripting

Match exact String with sed command

Discussion started by: mohtashims

10. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

Discussion started by: cmccabe

LEARN ABOUT SUSE

igawk