Golf majors; retreive data from Wikipedia articles

[DRSteele]

Can someone please help me?

I am trying to use PowerQuery to create a table in Excel of all the golf majors. I wish to extract their dates from the Wikipedia articles for each tournament.

For example, from this web address [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://en.wikipedia.org/wiki/1895_U.S._Open_(golf) I want the contents of the Dates field in the box on the upper right side, October 4 1895 in this case. Then 1896, then 1897 all the way to 2019. I reckon it's just some kind of parameter process but I can't seem to get it right.[/FONT]

 

[sandy666]

maybe from here: https://en.wikipedia.org/wiki/U.S._Open_(golf)

 

[DRSteele]

Unless I'm missing something, that page does not contain the dates. It is important that I have a method of retreiving various pieces of data from scores of web pages, not just the dates.

 

[sandy666]

maybe something like this:

[SIZE=1]// Select
let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Invoked Custom Function" = Table.AddColumn(Source, "fnUSOpen", each fnUSOpen([Select])),
    #"Expanded fnUSOpen" = Table.ExpandTableColumn(#"Invoked Custom Function", "fnUSOpen", {"Column1", "Column2"}, {"Column1", "Column2"})
in
    #"Expanded fnUSOpen"

// fnUSOpen
let
    YEAR=(year)=>
let
    Source = Web.Page(Web.Contents("https://en.wikipedia.org/wiki/"&(Text.From(year))&"_U.S._Open_(golf)")),
    Data0 = Source{0}[Data]
in
    Data0
in
    YEAR[/SIZE]

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Select[/td][td][/td][td][/td][td=bgcolor:#70AD47]Select[/td][td=bgcolor:#70AD47]Column1[/td][td=bgcolor:#70AD47]Column2[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]2018[/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Tournament information[/td][td=bgcolor:#E2EFDA]Tournament information[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]Dates[/td][td]June 14–17, 2018[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Location[/td][td=bgcolor:#E2EFDA]Shinnecock Hills, New York
40°53'38”N 72°26'24”W? / ?40.894°N 72.440°WCoordinates: 40°53'38”N 72°26'24”W? / ?40.894°N 72.440°W[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]Course(s)[/td][td]Shinnecock Hills Golf Club[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Organized by[/td][td=bgcolor:#E2EFDA]USGA[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]Tour(s)[/td][td]PGA Tour
European Tour
Japan Golf Tour[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA]Statistics[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]Par[/td][td]70[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Length[/td][td=bgcolor:#E2EFDA]7,440 yards (6,800 m)[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]Field[/td][td]156 players, 67 after cut[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Cut[/td][td=bgcolor:#E2EFDA]148 (+8)[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]Prize fund[/td][td]$12,000,000
€10,244,150[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Winner's share[/td][td=bgcolor:#E2EFDA]$2,160,000
€1,843,947[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]Champion[/td][td]Champion[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Brooks Koepka[/td][td=bgcolor:#E2EFDA]Brooks Koepka[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]281 (+1)[/td][td]281 (+1)[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]Location Map[/td][td=bgcolor:#E2EFDA]Location Map[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td]2018[/td][td]Shinnecock Hills
Location in the United States
Shinnecock Hills
Location in New York[/td][td]Shinnecock Hills
Location in the United States
Shinnecock Hills
Location in New York[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]2018[/td][td=bgcolor:#E2EFDA]‹ 2017
2019 ›[/td][td=bgcolor:#E2EFDA]‹ 2017
2019 ›[/td][/tr]
[/table]

 

[DRSteele]

Thanks Sandy. I had to alter and manipulate all kinds of things in the query, but I finally got 448 dates for golf's four major tournaments into one table. Not all years' webpages for each tourney are identical in shape and layout, so it took some doing.

It's still a mess from a formatting standpoint and dates before 1900 don't work in Excel. Certainly though this was much quicker than transcribing them all manually...wow. Much obliged.

 

[sandy666]

structure of the tables before 1987 is different than >=1987

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Select[/td][td=bgcolor:#70AD47]Title[/td][td=bgcolor:#70AD47]Label[/td][td=bgcolor:#70AD47]Detail[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1897​

[/td][td=bgcolor:#E2EFDA]Tournament information[/td][td=bgcolor:#E2EFDA]Dates[/td][td=bgcolor:#E2EFDA]September 17, 1897[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1897​

[/td][td]Tournament information[/td][td]Location[/td][td]Wheaton, Illinois[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1897​

[/td][td=bgcolor:#E2EFDA]Tournament information[/td][td=bgcolor:#E2EFDA]Course(s)[/td][td=bgcolor:#E2EFDA]Chicago Golf Club[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1897​

[/td][td]Tournament information[/td][td]Organized by[/td][td]USGA[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1897​

[/td][td=bgcolor:#E2EFDA]Tournament information[/td][td=bgcolor:#E2EFDA]Format[/td][td=bgcolor:#E2EFDA]Stroke play - 36 holes[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1897​

[/td][td]Statistics[/td][td]Field[/td][td]35[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1897​

[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA]Prize fund[/td][td=bgcolor:#E2EFDA]$335[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1897​

[/td][td]Statistics[/td][td]Winner's share[/td][td]$150[/td][/tr]
[/table]


[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Select[/td][td=bgcolor:#70AD47]Title[/td][td=bgcolor:#70AD47]Label[/td][td=bgcolor:#70AD47]Detail[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]Tournament information[/td][td=bgcolor:#E2EFDA]Tournament information[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1996​

[/td][td]Dates[/td][td]June 13–16, 1996[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]Location[/td][td=bgcolor:#E2EFDA]Bloomfield Hills, Michigan[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1996​

[/td][td]Course(s)[/td][td]Oakland Hills Country Club
South Course[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]Organized by[/td][td=bgcolor:#E2EFDA]USGA[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1996​

[/td][td]Tour(s)[/td][td]PGA Tour[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1996​

[/td][td]Par[/td][td]70[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]Length[/td][td=bgcolor:#E2EFDA]6,974 yards (6,377 m)[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1996​

[/td][td]Field[/td][td]156 players, 108 after cut[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]Cut[/td][td=bgcolor:#E2EFDA]148 (+8)[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1996​

[/td][td]Prize fund[/td][td]$2.4 million[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]Winner's share[/td][td=bgcolor:#E2EFDA]$425,000[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1996​

[/td][td]Champion[/td][td]Champion[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]Steve Jones[/td][td=bgcolor:#E2EFDA]Steve Jones[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1996​

[/td][td]278 (-2)[/td][td]278 (-2)[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

1996​

[/td][td=bgcolor:#E2EFDA]‹ 1995
1997 ›[/td][td=bgcolor:#E2EFDA]‹ 1995
1997 ›[/td][td=bgcolor:#E2EFDA][/td][/tr]
[/table]

 

[sandy666]

After posting I realized structure of the tables are different but as I can see you almost solved the problem
You didn't say what you are tryin' to achieve so M-code is simply for each single year
I used DV List to choose each year so it's a bit different from what you need

 

[sandy666]

in single table for all years
here is just breakthrough between 1986 and 1987

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]1987[/td][td]Tournament information[/td][td]Tournament information[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Dates[/td][td=bgcolor:#E2EFDA]June 18–21, 1987[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Location[/td][td]San Francisco, California[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Course(s)[/td][td=bgcolor:#E2EFDA]Olympic Club, Lake Course[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Organized by[/td][td]USGA[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Tour(s)[/td][td=bgcolor:#E2EFDA]PGA Tour[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Format[/td][td]Stroke play[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Par[/td][td]70[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Length[/td][td=bgcolor:#E2EFDA]6,709 yards (6,135 m)[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Field[/td][td]156 players, 77 after cut[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Cut[/td][td=bgcolor:#E2EFDA]147 (+7)[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Prize fund[/td][td]$825,000[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Winner's share[/td][td=bgcolor:#E2EFDA]$150,000[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Champion[/td][td]Champion[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Scott Simpson[/td][td=bgcolor:#E2EFDA]Scott Simpson[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]277 (-3)[/td][td]277 (-3)[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]‹ 1986
1988 ›[/td][td=bgcolor:#E2EFDA]‹ 1986
1988 ›[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]1986[/td][td]Tournament information[/td][td]Dates[/td][td]June 12–15, 1986[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1986[/td][td=bgcolor:#E2EFDA]Tournament information[/td][td=bgcolor:#E2EFDA]Location[/td][td=bgcolor:#E2EFDA]Shinnecock Hills, New York[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1986[/td][td]Tournament information[/td][td]Course(s)[/td][td]Shinnecock Hills Golf Club[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1986[/td][td=bgcolor:#E2EFDA]Tournament information[/td][td=bgcolor:#E2EFDA]Organized by[/td][td=bgcolor:#E2EFDA]USGA[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1986[/td][td]Tournament information[/td][td]Tour(s)[/td][td]PGA Tour[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1986[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA]Par[/td][td=bgcolor:#E2EFDA]70[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1986[/td][td]Statistics[/td][td]Length[/td][td]6,912 yards (6,320 m)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1986[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA]Field[/td][td=bgcolor:#E2EFDA]155 players, 70 after cut[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1986[/td][td]Statistics[/td][td]Cut[/td][td]150 (+10)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1986[/td][td=bgcolor:#E2EFDA]Statistics[/td][td=bgcolor:#E2EFDA]Prize fund[/td][td=bgcolor:#E2EFDA]$700,000[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1986[/td][td]Statistics[/td][td]Winner's share[/td][td]$115,000[/td][/tr]
[/table]

 

[sandy666]

and end result

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Dates[/td][td=bgcolor:#9BC2E6]June 16–20, 1988[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Location[/td][td=bgcolor:#9BC2E6]Brookline, Massachusetts[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Course(s)[/td][td=bgcolor:#9BC2E6]The Country Club
Composite Course[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Tour(s)[/td][td=bgcolor:#9BC2E6]PGA Tour[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Par[/td][td=bgcolor:#9BC2E6]71[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Length[/td][td=bgcolor:#9BC2E6]7,010 yards (6,410 m)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Field[/td][td=bgcolor:#9BC2E6]156 players, 65 after cut[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Cut[/td][td=bgcolor:#9BC2E6]146 (+4)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Prize fund[/td][td=bgcolor:#9BC2E6]$1.0 miilion[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Winner's share[/td][td=bgcolor:#9BC2E6]$180,000[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]Curtis Strange[/td][td=bgcolor:#9BC2E6]Curtis Strange[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]278 (-6), playoff[/td][td=bgcolor:#9BC2E6]278 (-6), playoff[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1988[/td][td=bgcolor:#9BC2E6]‹ 1987
1989 ›[/td][td=bgcolor:#9BC2E6]‹ 1987
1989 ›[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Dates[/td][td]June 18–21, 1987[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Location[/td][td=bgcolor:#E2EFDA]San Francisco, California[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Course(s)[/td][td]Olympic Club, Lake Course[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Organized by[/td][td=bgcolor:#E2EFDA]USGA[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Tour(s)[/td][td]PGA Tour[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Format[/td][td=bgcolor:#E2EFDA]Stroke play[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Par[/td][td]70[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Length[/td][td=bgcolor:#E2EFDA]6,709 yards (6,135 m)[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Field[/td][td]156 players, 77 after cut[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Cut[/td][td=bgcolor:#E2EFDA]147 (+7)[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Prize fund[/td][td]$825,000[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]Winner's share[/td][td=bgcolor:#E2EFDA]$150,000[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]Scott Simpson[/td][td]Scott Simpson[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1987[/td][td=bgcolor:#E2EFDA]277 (-3)[/td][td=bgcolor:#E2EFDA]277 (-3)[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1987[/td][td]‹ 1986
1988 ›[/td][td]‹ 1986
1988 ›[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Dates[/td][td=bgcolor:#9BC2E6]June 12–15, 1986[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Location[/td][td=bgcolor:#9BC2E6]Shinnecock Hills, New York[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Course(s)[/td][td=bgcolor:#9BC2E6]Shinnecock Hills Golf Club[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Organized by[/td][td=bgcolor:#9BC2E6]USGA[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Tour(s)[/td][td=bgcolor:#9BC2E6]PGA Tour[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Par[/td][td=bgcolor:#9BC2E6]70[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Length[/td][td=bgcolor:#9BC2E6]6,912 yards (6,320 m)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Field[/td][td=bgcolor:#9BC2E6]155 players, 70 after cut[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Cut[/td][td=bgcolor:#9BC2E6]150 (+10)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Prize fund[/td][td=bgcolor:#9BC2E6]$700,000[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#9BC2E6]1986[/td][td=bgcolor:#9BC2E6]Winner's share[/td][td=bgcolor:#9BC2E6]$115,000[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1985[/td][td]Dates[/td][td]June 13–16, 1985[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1985[/td][td=bgcolor:#E2EFDA]Location[/td][td=bgcolor:#E2EFDA]Bloomfield Hills, Michigan[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1985[/td][td]Course(s)[/td][td]Oakland Hills Country Club, South Course[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1985[/td][td=bgcolor:#E2EFDA]Tour(s)[/td][td=bgcolor:#E2EFDA]PGA Tour[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1985[/td][td]Par[/td][td]70[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1985[/td][td=bgcolor:#E2EFDA]Length[/td][td=bgcolor:#E2EFDA]6,996 yards (6,397 m)[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1985[/td][td]Field[/td][td]156 players, 66 after cut[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1985[/td][td=bgcolor:#E2EFDA]Cut[/td][td=bgcolor:#E2EFDA]146 (+6)[/td][/tr]

[tr=bgcolor:#FFFFFF][td]1985[/td][td]Prize fund[/td][td]$650,000[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]1985[/td][td=bgcolor:#E2EFDA]Winner's share[/td][td=bgcolor:#E2EFDA]$103,000[/td][/tr]
[/table]

 

[DRSteele]

Sandy, thanks for your dedication here. I was able to create a column under the field Select containing all the dates from 1860 onward. When the Query was invoked, some of the webpages reported an error becsue they don't exist, notably for the war years like 1917 and 1943. I then altered the M-code to reflect each of the four tournaments and to report the Dates only. As you noticed for the US_Open, there were years for each tournament when the Query stopped working and needed to have its columns adjusted. After these tinkerings, the Query reported a long column of Dates for each tournament and I now have 448 dates for the four major tournaments.

Dealing with these dates is the new challenge. Here is a sample of my output. I will need to somehow create a start date and an end date for each tournament, which won't be easy because they are all laid out differently across and within each field.

[TABLE="width: 751"]
[TR]
[TD]open[/TD]
[TD]usopen[/TD]
[TD]pga[/TD]
[TD]masters[/TD]
[/TR]
[TR]
[TD]17 October 1860[/TD]
[TD]October 4, 1895[/TD]
[TD]October 10–14, 1916[/TD]
[TD]March 22–25, 1934[/TD]
[/TR]
[TR]
[TD]26 September 1861[/TD]
[TD]July 18, 1896[/TD]
[TD]September 16–20, 1919[/TD]
[TD]April 4–8, 1935[/TD]
[/TR]
[TR]
[TD]11 September 1862[/TD]
[TD]September 17, 1897[/TD]
[TD]August 17–21, 1920[/TD]
[TD]April 3–6, 1936[/TD]
[/TR]
[TR]
[TD]18 September 1863[/TD]
[TD]June 17–18, 1898[/TD]
[TD]August 14–18, 1922[/TD]
[TD]April 1–4, 1937[/TD]
[/TR]
[TR]
[TD]16 September 1864[/TD]
[TD]September 14–15, 1899[/TD]
[TD]September 24–29, 1923[/TD]
[TD]April 2–4, 1938[/TD]
[/TR]
[TR]
[TD]14 September 1865[/TD]
[TD]October 4–5, 1900[/TD]
[TD]September 15–20, 1924[/TD]
[TD]March 31 – April 2, 1939[/TD]
[/TR]
[TR]
[TD]13 September 1866[/TD]
[TD]June 14–17, 1901[/TD]
[TD]September 21–26, 1925[/TD]
[TD]April 4–7, 1940[/TD]
[/TR]
[TR]
[TD]26 September 1867[/TD]
[TD]October 10–11, 1902[/TD]
[TD]September 20–25, 1926[/TD]
[TD]April 3–6, 1941[/TD]
[/TR]
[TR]
[TD]23 September 1868[/TD]
[TD]June 26–29, 1903[/TD]
[TD]October 31 –

November 5, 1927[/TD]
[TD]April 9–13, 1942[/TD]
[/TR]
[TR]
[TD]16 September 1869[/TD]
[TD]July 8–9, 1904[/TD]
[TD]October 1–6, 1928[/TD]
[TD]April 4–7, 1946[/TD]
[/TR]
[TR]
[TD]15 September 1870[/TD]
[TD]September 21–22, 1905[/TD]
[TD]December 2–7, 1929[/TD]
[TD]April 3–6, 1947[/TD]
[/TR]
[TR]
[TD]13 September 1872[/TD]
[TD]June 28–29, 1906[/TD]
[TD]September 8–13, 1930[/TD]
[TD]April 8–11, 1948[/TD]
[/TR]
[TR]
[TD]4 October 1873[/TD]
[TD]June 20–21, 1907[/TD]
[TD]September 14–19, 1931[/TD]
[TD]April 7–10, 1949[/TD]
[/TR]
[TR]
[TD]10 April 1874[/TD]
[TD]August 27–29, 1908[/TD]
[TD]August 30 –

September 4, 1932[/TD]
[TD]April 6–9, 1950[/TD]
[/TR]
[TR]
[TD]10 September 1875[/TD]
[TD]June 24–25, 1909[/TD]
[TD]August 8–13, 1933[/TD]
[TD]April 5–8, 1951[/TD]
[/TR]
[TR]
[TD]30 September, 2 October 1876[/TD]
[TD]June 17–20, 1910[/TD]
[TD]July 24–29, 1934[/TD]
[TD]April 3–6, 1952[/TD]
[/TR]
[TR]
[TD]6 April 1877[/TD]
[TD]June 23–26, 1911[/TD]
[TD]October 17–23, 1935[/TD]
[TD]April 9–12, 1953[/TD]
[/TR]
[TR]
[TD]4 October 1878[/TD]
[TD]August 1–2, 1912[/TD]
[TD]May 24–30, 1937[/TD]
[TD]April 8–12, 1954[/TD]
[/TR]
[TR]
[TD]27, 29 September 1879[/TD]
[TD]September 18–20, 1913[/TD]
[TD]July 10–16, 1938[/TD]
[TD]April 7–10, 1955[/TD]
[/TR]
[TR]
[TD]9 April 1880[/TD]
[TD]August 20–21, 1914[/TD]
[TD]July 9–15, 1939[/TD]
[TD]April 5–8, 1956[/TD]
[/TR]
[/TABLE]