Extract values from a specific column of an html table using bash

Question

I have an html table in which the first row is the title and the next rows represent the body of the table. I want to extract the values from the 3'rd column of each row. How can I proceed?

Avinash Raj · Accepted Answer · 2014-11-25 13:20:49Z

1

Try the below awk command,

awk 'NR>1{print $3}' file

This prints the value of third column except the one in the header.

Update:

awk -v RS='</tr>' -v F='<td>' '{$3=gsub(/<[^<>]*>/,"",$3);print $3}' file

edited Nov 25, 2014 at 13:20

answered Nov 25, 2014 at 12:59

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ciprian Vintea Over a year ago

No. It doesn't work. I think a delimiter (<td>) should be used in this case.

Avinash Raj Over a year ago

could you provide an example along with expected output?

Ciprian Vintea Over a year ago

awk -v RS='</tr>' -v F='<td>' '{print $3}' - this will print <td>value</td>. How can I extract the value from here?

Avinash Raj Over a year ago

awk -v RS='</tr>' -v F='<td>' '{$3=gsub(/<[^<>]*>/,"",$3);print $3}' file

Collectives™ on Stack Overflow

Extract values from a specific column of an html table using bash

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related