Awk/sed HTML extract Post: 302978555

Sponsored Content

Top Forums Shell Programming and Scripting Awk/sed HTML extract Post 302978555 by p1ne on Monday 1st of August 2016 08:45:17 AM

08-01-2016

Registered User

Thanks RudiC, those are both very close. I probably should have posted table structure because the sed commands are returning some fields from other table elements. I just need the text in between <th> a href from the "Automobile" heading:

Code:

<table class="wikitable sortable" style="font-size:90%">
<tr>
<th style="width:5em">Image</th>
<th style="width:15em">Automobile</th>
<th style="width:10em">Production</th>
<th style="width:15em">Units Sold</th>
<th style="width:10em">Years sold</th>
<th style="width:25em">Notes</th>
</tr>
<tr>
<td>
<div class="center">
<div class="floatnone"><a href="/wiki/File:Late_model_Ford_Model_T.jpg" class="image" title="1927 Ford Model-T."><img alt="1927 Ford Model-T." src="//upload.wikimedia.org/wikipedia/commons/thumb/1/15/Late_model_Ford_Model_T.jpg/100px-Late_model_Ford_Model_T.jpg" width="100" height="91" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/1/15/Late_model_Ford_Model_T.jpg/150px-Late_model_Ford_Model_T.jpg 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/1/15/Late_model_Ford_Model_T.jpg/200px-Late_model_Ford_Model_T.jpg 2x" data-file-width="400" data-file-height="365" /></a></div>
</div>
</td>
<th><a href="/wiki/Ford_Model_T" title="Ford Model T">Ford Model T</a></th>
<td>1908-27</td>
<td><b>16,500,000</b><sup id="cite_ref-ford_7-0" class="reference"><a href="#cite_note-ford-7">[7]</a></sup></td>
<td>1908-27</td>
<td>The first car to achieve one million, five million, ten million and fifteen million units sold. By 1914, it was estimated that nine out of every ten cars in the world were <a href="/wiki/Ford_Motor_Company" title="Ford Motor Company">Fords</a>.<sup id="cite_ref-ford_7-1" class="reference"><a href="#cite_note-ford-7">[7]</a></sup></td>
</tr>

Thanks for your time.

Re: rdtx1 awk command, thanks, that prints blank file beyond $1 (prints full doc). I tried up to $6).

p1ne

View Public Profile for p1ne

Find all posts by p1ne

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I extract text only from html file without HTML tag

I have a html file called myfile. If I simply put "cat myfile.html" in UNIX, it shows all the html tags like <a href=r/26><img src="http://www>. But I want to extract only text part. Same problem happens in "type" command in MS-DOS. I know you can do it by opening it in Internet Explorer,...

2. UNIX for Advanced & Expert Users

sed to extract HTML content

Hiya, I am trying to extract a news article from a web page. The sed I have written brings back a lot of Javascript code and sometimes advertisments too. Can anyone please help with this one ??? I need to fix this sed so it picks up the article ONLY (don't worry about the title or date .. i got...

3. Shell Programming and Scripting

sed to extract only floating point numbers from HTML

Hi All, I'm trying to extract some floating point numbers from within some HTML code like this: <TR><TD class='awrc'>Parse CPU to Parse Elapsd %:</TD><TD ALIGN='right' class='awrc'> 64.50</TD><TD class='awrc'>% Non-Parse CPU:</TD><TD ALIGN='right' class='awrc'> ...

4. Shell Programming and Scripting

Extract URLs from HTML code using sed

Hello, i try to extract urls from google-search-results, but i have problem with sed filtering of html-code. what i wont is just list of urls thay apears between ........<p><a href=" and next following " in html code. here is my code, i use wget and pipelines to filtering. wget works, but...

5. Shell Programming and Scripting

SED to extract HTML text data, not quite right!

I am attempting to extract weather data from the following website, but for the Victoria area only: Text Forecasts - Environment Canada I use this: sed -n "/Greater Victoria./,/Fraser Valley./p" But that phrasing does not sometimes get it all and think perhaps the website has more...

6. Shell Programming and Scripting

extract data with awk from html files

Hello everyone, I'm new to this forum and i am new as a shell scripter. my problem is to have html files in a directory and I would like to extract from these some data that lies between two different lines Here's my situation <td align="default"> oxidizability (mg / l): data_to_extract...

7. Shell Programming and Scripting

help with sed needed to extract content from html tags

Hi I've searched for it for few hours now and i can't seem to find anything working like i want. I've got webpage, saved in file par with form like this: <html><body><form name='sendme' action='http://example.com/' method='POST'> <textarea name='1st'>abc123def678</textarea> <textarea...

8. Shell Programming and Scripting

awk -- Extract data from html within multiple tags as reference

Hi, I'm trying to get some data from an html file, but the problem is before it can extract the information I have multiple patterns that need to be passed through. https://www.unix.com/shell-programming-scripting/150711-extract-data-awk-html-files.html Is a similar problem. The only...

9. Shell Programming and Scripting

Extract text from html using perl or awk

I am trying to extract text after keywords fron an html file. The keywords are reportLink":, "barcodedSamples": {", "barcodedSamples": {". Both the perl and awk run but the output is just the entire index.html not the desired output. Also for the reportLink": only the text after the second / until...

10. UNIX for Beginners Questions & Answers

awk to extract value after keyword in html

Using awk to extract value after a keyword in an html, and store in ts. The awk does execute but ts is empty. I use the tag as a delimiter and the keyword as a pattern, but there probably is a better way. Thank you :). file <html><head><title>xxxxxx xxxxx</title><style type="text/css"> ...

LEARN ABOUT DEBIAN

fox

FOX(1)							      General Commands Manual							    FOX(1)

NAME

       fox - ab-initio structure determination from diffraction data

SYNOPSIS

       fox [options] [file.xml]

DESCRIPTION

       The  fox  (Free Objects for Crystallography) program was made for the ab initio crystal structure solution from diffraction data.  Its most
       interesting features for ab initio structure determination are:

       * versatile description of the crystal contents;

       * automatic correction for special positions and shared atoms between polyhedra;

       * the ability to use simultaneously multiple powder patterns;

       * smart global optimization algorithms;

       * a graphical interface with a 3D crystal structure view and live updates during the optimization process.

OPTIONS

       This program my be executed with or without command line options or input file (file.xml).  It follows the usual GNU command  line  syntax,
       with  long  options  starting with two dashes (`-').  A summary of options is included below.  For a complete description, see the fox wiki
       http://objcryst.sourceforge.net/Fox/Manual

       --help Show summary of options.

       --loadfouriergrd map.grd
	      Load and display 'map.grd' fourier map with (first) crystal structure

       --loadfourierdsn6 map.DN6
	      Load and display a DSN6 fourier map with (first) crystal structure

       --nogui
	      Run without GUI, automatically launches optimization --nogui may be accompanied by the following options:

       -n 10000
	      Run for 10000 trials at most (default: 1000000)

       --nbrun 5
	      Do 5 runs, randomizing before each run (default: 1), use -1 to run indefinitely

       -o out.xml
	      Output in 'out.xml'

       --randomize
	      Randomize initial configuration

       --silent
	      Produce (almost) no text output

       --finalcost 0.15
	      Run optimization until cost < 0.15

       --cif2pattern 1.5406 170 5000 .1
	      Simulate pattern for input crystal, wavelength=1.5406 up to 170o with 500 points anda peak width of 0.1o

EXAMPLES

       Fox silicon.xml
	      Load file 'silicon.xml' and launch GUI.

       Fox Cimetidine-powder.xml --nogui --randomize -n 1000000 -o best.xml
	      Load file 'ktartrate.xml', randomize, then make 1 optimization of 1 million trials, and save the best structure in 'best.xml'.

       Fox Cimetidine-powder.xml --nogui --randomize -n 10000000 --nbrun 10 -o best.xml
	      Load file 'Cimetidine-powder.xml', then make 10 runs (starting from a random structure) of 10 million trials (each run saves one xml
	      file), and save the best structure in 'best.xml'.

       Fox Cimetidine-powder.xml --nogui --silent --randomize -n 10000000 --nbrun 10 --finalcost 200000 -o best.xml
	      Load  file  'Cimetidine-powder.xml',  then make 10 silent runs of 10 million trials (each run saves one xml file), and save the best
	      structure in 'best.xml'.	For each run, the optimization stops if the cost goes below 200000.

AUTHOR

       fox was written by Vincent Favre-Nicolin <Vincent.Favre-Nicolin@cea.fr>.

       This manual page was written by Carlo Segre <segre@debian.org>, for the Debian project (but may be used by others).

								   July 24, 2008							    FOX(1)