How to extract data from html table in shell script?

by

Go with (g)awk, it’s capable :-), here is a solution, but please note: it’s only working with the exact html table format you had posted.

 awk -F "</*td>|</*tr>" '/<\/*t[rd]>.*[A-Z][A-Z]/ {print $3, $5, $7 }' FILE

Here you can see it in action: https://ideone.com/zGfLe

Some explanation:

  1. -F sets the input field separator to a regexp (any of tr‘s or td‘s opening or closing tag

  2. then works only on lines that matches those tags AND at least two upercasse fields

  3. then prints the needed fields.

HTH

More Related Contents:

  1. Regex select all text between tags
  2. How do HTML parses work if they’re not using regexp?
  3. Easiest way to extract the urls from an html page using sed or awk only
  4. What to do Regular expression pattern doesn’t match anywhere in string?
  5. Can you provide some examples of why it is hard to parse XML and HTML with a regex? [closed]
  6. How to extract img src, title and alt from html using php? [duplicate]
  7. Can you provide examples of parsing HTML?
  8. RegEx match open tags except XHTML self-contained tags
  9. html parsing of cricinfo scorecards
  10. Regular expression to remove HTML tags from a string [duplicate]
  11. Trouble with parsing table data in perl
  12. Regular expression for extracting tag attributes
  13. Regex replace text outside html tags
  14. Run a shell script with an html button
  15. Sed remove tags from html file
  16. regular expression to extract text from HTML
  17. Why does a stray end tag generate an empty paragraph?
  18. How to extract string following a pattern with grep, regex or perl [duplicate]
  19. highlight words in html using regex & javascript – almost there
  20. HTML parsing in perl
  21. Regex to match all HTML tags except and
  22. Sed to extract text between two strings
  23. Strip all HTML tags except links
  24. Convert html to plain text in VBA
  25. Parse html using C
  26. Are single/double quotes allowed inside HTML attribute values?
  27. tools for obfuscating html and css [closed]
  28. CSS transform origin issue on svg sub-element
  29. HTML: Characters allowed for name attribute of input element?
  30. CSS Layout 2-Column fixed-fluid [closed]

Leave a Comment