Awk to filter table

up vote
3
down vote

favorite

I need some help with awk. I need to Write an awk command that will return the Identification number from the following table for only the lines where the title is "Turtle". This table is stored in turtle.txt

Id Num. Title CatchDate
433417 RedTurtle 2001-06-29
493303 BlueTurtle 1998-09-20
259497 Turtle 1985-05-08
229505 RedTurtle 1994-07-13
473076 OrangeTurtle 2002-03-08
221907 Blueturtle 1999-07-02
457032 Turtle 1993-04-09
490359 RedTurtle 1996-11-12
494595 SnappingTurtle 1985-05-20
402421 BlueTurtle 1999-08-16

Any help would be very much appreciated

edited 28 mins ago

Isaac

7,79711137

asked 34 mins ago

Kamat

161

New contributor

add a commentÂ |Â

up vote
3
down vote

favorite

Id Num. Title CatchDate
433417 RedTurtle 2001-06-29
493303 BlueTurtle 1998-09-20
259497 Turtle 1985-05-08
229505 RedTurtle 1994-07-13
473076 OrangeTurtle 2002-03-08
221907 Blueturtle 1999-07-02
457032 Turtle 1993-04-09
490359 RedTurtle 1996-11-12
494595 SnappingTurtle 1985-05-20
402421 BlueTurtle 1999-08-16

Any help would be very much appreciated

edited 28 mins ago

Isaac

7,79711137

asked 34 mins ago

Kamat

161

New contributor

add a commentÂ |Â

up vote
3
down vote

favorite

Id Num. Title CatchDate
433417 RedTurtle 2001-06-29
493303 BlueTurtle 1998-09-20
259497 Turtle 1985-05-08
229505 RedTurtle 1994-07-13
473076 OrangeTurtle 2002-03-08
221907 Blueturtle 1999-07-02
457032 Turtle 1993-04-09
490359 RedTurtle 1996-11-12
494595 SnappingTurtle 1985-05-20
402421 BlueTurtle 1999-08-16

Any help would be very much appreciated

edited 28 mins ago

Isaac

7,79711137

asked 34 mins ago

Kamat

161

New contributor

Id Num. Title CatchDate
433417 RedTurtle 2001-06-29
493303 BlueTurtle 1998-09-20
259497 Turtle 1985-05-08
229505 RedTurtle 1994-07-13
473076 OrangeTurtle 2002-03-08
221907 Blueturtle 1999-07-02
457032 Turtle 1993-04-09
490359 RedTurtle 1996-11-12
494595 SnappingTurtle 1985-05-20
402421 BlueTurtle 1999-08-16

Any help would be very much appreciated

bash

edited 28 mins ago

Isaac

7,79711137

asked 34 mins ago

Kamat

161

New contributor

edited 28 mins ago

Isaac

7,79711137

asked 34 mins ago

Kamat

161

New contributor

edited 28 mins ago

Isaac

7,79711137

edited 28 mins ago

Isaac

7,79711137

edited 28 mins ago

Isaac

7,79711137

asked 34 mins ago

Kamat

161

New contributor

asked 34 mins ago

Kamat

161

asked 34 mins ago

Kamat

161

New contributor

Kamat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a commentÂ |Â

5 Answers
5

active

oldest

votes

up vote
5
down vote

You can use:

awk '$2 == "Turtle" print $1' file
259497
457032

edited 27 mins ago

answered 32 mins ago

Goro

7,48253169

add a commentÂ |Â

up vote
5
down vote

awk '$2 == "Turtle" print $1' turtle.txt
259497
457032

$2 is the field to select

Turtle is the text to match

print $1 is to print the first field.

turtle.txt is the name of the source file.

edited 10 mins ago

answered 32 mins ago

Isaac

7,79711137

add a commentÂ |Â

up vote
3
down vote

non-awk alternative:

grep -w "Turtle" turtle.txt | cut -d " " -f 1

answered 30 mins ago

RobotJohnny

740216

add a commentÂ |Â

up vote
3
down vote

Using sed:

sed -n '/sTurtles/s/^([0-9]+)s.*/1/p' file

answered 23 mins ago

oliv

1,121210

add a commentÂ |Â

up vote
3
down vote

Golfing it:

$ awk '$2=="Turtle"&&$0=$1' <file
259497
457032

Or, expanded in stages until we reach Isaac's and Goro's answers

awk '$2 == "Turtle" && $0 = $1' <file

awk '$2 == "Turtle" $0 = $1; print ' <file

awk '$2 == "Turtle" print $1 ' <file

The three are not exactly equivalent as my golfed code would not print the number if it was zero.

Here's a proper sed solution to make up for the golfing above:

$ sed -n '/<Turtle>/s/ .*//p' <file
259497
457032

answered 6 mins ago

Kusalananda

108k14210333

add a commentÂ |Â

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

Kamat is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f473978%2fawk-to-filter-table%23new-answer', 'question_page');

);

Post as a guest

Name

5 Answers
5

active

oldest

votes

5 Answers
5

active

oldest

votes

up vote
5
down vote

You can use:

awk '$2 == "Turtle" print $1' file
259497
457032

edited 27 mins ago

answered 32 mins ago

Goro

7,48253169

add a commentÂ |Â

up vote
5
down vote

You can use:

awk '$2 == "Turtle" print $1' file
259497
457032

edited 27 mins ago

answered 32 mins ago

Goro

7,48253169

add a commentÂ |Â

up vote
5
down vote

You can use:

awk '$2 == "Turtle" print $1' file
259497
457032

edited 27 mins ago

answered 32 mins ago

Goro

7,48253169

You can use:

awk '$2 == "Turtle" print $1' file
259497
457032

edited 27 mins ago

answered 32 mins ago

Goro

7,48253169

edited 27 mins ago

answered 32 mins ago

Goro

7,48253169

answered 32 mins ago

Goro

7,48253169

answered 32 mins ago

Goro

7,48253169

add a commentÂ |Â

up vote
5
down vote

awk '$2 == "Turtle" print $1' turtle.txt
259497
457032

$2 is the field to select

Turtle is the text to match

print $1 is to print the first field.

turtle.txt is the name of the source file.

edited 10 mins ago

answered 32 mins ago

Isaac

7,79711137

add a commentÂ |Â

up vote
5
down vote

awk '$2 == "Turtle" print $1' turtle.txt
259497
457032

$2 is the field to select

Turtle is the text to match

print $1 is to print the first field.

turtle.txt is the name of the source file.

edited 10 mins ago

answered 32 mins ago

Isaac

7,79711137

add a commentÂ |Â

up vote
5
down vote

awk '$2 == "Turtle" print $1' turtle.txt
259497
457032

$2 is the field to select

Turtle is the text to match

print $1 is to print the first field.

turtle.txt is the name of the source file.

edited 10 mins ago

answered 32 mins ago

Isaac

7,79711137

awk '$2 == "Turtle" print $1' turtle.txt
259497
457032

$2 is the field to select

Turtle is the text to match

print $1 is to print the first field.

turtle.txt is the name of the source file.

edited 10 mins ago

answered 32 mins ago

Isaac

7,79711137

edited 10 mins ago

answered 32 mins ago

Isaac

7,79711137

answered 32 mins ago

Isaac

7,79711137

answered 32 mins ago

Isaac

7,79711137

add a commentÂ |Â

up vote
3
down vote

non-awk alternative:

grep -w "Turtle" turtle.txt | cut -d " " -f 1

answered 30 mins ago

RobotJohnny

740216

add a commentÂ |Â

up vote
3
down vote

non-awk alternative:

grep -w "Turtle" turtle.txt | cut -d " " -f 1

answered 30 mins ago

RobotJohnny

740216

add a commentÂ |Â

up vote
3
down vote

non-awk alternative:

grep -w "Turtle" turtle.txt | cut -d " " -f 1

answered 30 mins ago

RobotJohnny

740216

non-awk alternative:

grep -w "Turtle" turtle.txt | cut -d " " -f 1

answered 30 mins ago

RobotJohnny

740216

answered 30 mins ago

RobotJohnny

740216

answered 30 mins ago

RobotJohnny

740216

answered 30 mins ago

RobotJohnny

740216

add a commentÂ |Â

up vote
3
down vote

Using sed:

sed -n '/sTurtles/s/^([0-9]+)s.*/1/p' file

answered 23 mins ago

oliv

1,121210

add a commentÂ |Â

up vote
3
down vote

Using sed:

sed -n '/sTurtles/s/^([0-9]+)s.*/1/p' file

answered 23 mins ago

oliv

1,121210

add a commentÂ |Â

up vote
3
down vote

Using sed:

sed -n '/sTurtles/s/^([0-9]+)s.*/1/p' file

answered 23 mins ago

oliv

1,121210

Using sed:

sed -n '/sTurtles/s/^([0-9]+)s.*/1/p' file

answered 23 mins ago

oliv

1,121210

answered 23 mins ago

oliv

1,121210

answered 23 mins ago

oliv

1,121210

answered 23 mins ago

oliv

1,121210

add a commentÂ |Â

up vote
3
down vote

Golfing it:

$ awk '$2=="Turtle"&&$0=$1' <file
259497
457032

Or, expanded in stages until we reach Isaac's and Goro's answers

awk '$2 == "Turtle" && $0 = $1' <file

awk '$2 == "Turtle" $0 = $1; print ' <file

awk '$2 == "Turtle" print $1 ' <file

The three are not exactly equivalent as my golfed code would not print the number if it was zero.

Here's a proper sed solution to make up for the golfing above:

$ sed -n '/<Turtle>/s/ .*//p' <file
259497
457032

answered 6 mins ago

Kusalananda

108k14210333

add a commentÂ |Â

up vote
3
down vote

Golfing it:

$ awk '$2=="Turtle"&&$0=$1' <file
259497
457032

Or, expanded in stages until we reach Isaac's and Goro's answers

awk '$2 == "Turtle" && $0 = $1' <file

awk '$2 == "Turtle" $0 = $1; print ' <file

awk '$2 == "Turtle" print $1 ' <file

The three are not exactly equivalent as my golfed code would not print the number if it was zero.

Here's a proper sed solution to make up for the golfing above:

$ sed -n '/<Turtle>/s/ .*//p' <file
259497
457032

answered 6 mins ago

Kusalananda

108k14210333

add a commentÂ |Â

up vote
3
down vote

Golfing it:

$ awk '$2=="Turtle"&&$0=$1' <file
259497
457032

Or, expanded in stages until we reach Isaac's and Goro's answers

awk '$2 == "Turtle" && $0 = $1' <file

awk '$2 == "Turtle" $0 = $1; print ' <file

awk '$2 == "Turtle" print $1 ' <file

The three are not exactly equivalent as my golfed code would not print the number if it was zero.

Here's a proper sed solution to make up for the golfing above:

$ sed -n '/<Turtle>/s/ .*//p' <file
259497
457032

answered 6 mins ago

Kusalananda

108k14210333

Golfing it:

$ awk '$2=="Turtle"&&$0=$1' <file
259497
457032

Or, expanded in stages until we reach Isaac's and Goro's answers

awk '$2 == "Turtle" && $0 = $1' <file

awk '$2 == "Turtle" $0 = $1; print ' <file

awk '$2 == "Turtle" print $1 ' <file

The three are not exactly equivalent as my golfed code would not print the number if it was zero.

Here's a proper sed solution to make up for the golfing above:

$ sed -n '/<Turtle>/s/ .*//p' <file
259497
457032

answered 6 mins ago

Kusalananda

108k14210333

answered 6 mins ago

Kusalananda

108k14210333

answered 6 mins ago

Kusalananda

108k14210333

answered 6 mins ago

Kusalananda

108k14210333

add a commentÂ |Â

Kamat is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Kamat is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Post as a guest

Name

Search This Blog

Iyfjky