Talk:Lists of The New York Times number-one books

Microsoft Word find and replace

Example: http://www.hawes.com/1950/1950-01-01.pdf

Copy and paste into Microsoft Word.

1 THE EGYPTIAN, by Mika Waltari. 1 17
2 MARY, by Sholem Asch. 2 11
3 A RAGE TO LIVE, by John O'Hara. 3 18
4 THE WAY WEST, by A.B. Guthrie Jr. 4 10
5 ONE ON THE HOUSE, by Mary Lasswell. 5 4
6 THE WOMAN OF ROME, by Alberto Moravia. 6 6
7 THE BIG FISHERMAN, by Lloyd C. Douglas. 9 57
8 LET LOVE COME LAST, by Taylor Caldwell. 8 20
9 THE MAN WITH THE GOLDEN ARM, by Nelson Algren. 12 14
10 THE MUDLARK, by Theodore Bonnet. 10 18
11 LOVING, by Henry Green. 7 9
12 PRINCE OF EGYPT, by Dorothy Clarke Wilson. -- 2
13 THE DREAM MERCHANTS, by Harold Robbins. 16 8
14 CRY, THE BELOVED COUNTRY, by Alan Paton. 11 24
15 THE SHELTERING SKY, by Paul Bowles. -- 1
16 GYPSY SIXPENCE, by Edison Marshall. -- 7

Click Edit >> Replace (Ctrl+H)

First replace: -- with 0.

1 THE EGYPTIAN, by Mika Waltari. 1 17 2 MARY, by Sholem Asch. 2 11 3 A RAGE TO LIVE, by John O'Hara. 3 18 4 THE WAY WEST, by A.B. Guthrie Jr. 4 10 5 ONE ON THE HOUSE, by Mary Lasswell. 5 4 6 THE WOMAN OF ROME, by Alberto Moravia. 6 6 7 THE BIG FISHERMAN, by Lloyd C. Douglas. 9 57 8 LET LOVE COME LAST, by Taylor Caldwell. 8 20 9 THE MAN WITH THE GOLDEN ARM, by Nelson Algren. 12 14 10 THE MUDLARK, by Theodore Bonnet. 10 18 11 LOVING, by Henry Green. 7 9 12 PRINCE OF EGYPT, by Dorothy Clarke Wilson. -- 2 13 THE DREAM MERCHANTS, by Harold Robbins. 16 8 14 CRY, THE BELOVED COUNTRY, by Alan Paton. 11 24 15 THE SHELTERING SKY, by Paul Bowles. -- 1 16 GYPSY SIXPENCE, by Edison Marshall. -- 7

→

1 THE EGYPTIAN, by Mika Waltari. 1 17 2 MARY, by Sholem Asch. 2 11 3 A RAGE TO LIVE, by John O'Hara. 3 18 4 THE WAY WEST, by A.B. Guthrie Jr. 4 10 5 ONE ON THE HOUSE, by Mary Lasswell. 5 4 6 THE WOMAN OF ROME, by Alberto Moravia. 6 6 7 THE BIG FISHERMAN, by Lloyd C. Douglas. 9 57 8 LET LOVE COME LAST, by Taylor Caldwell. 8 20 9 THE MAN WITH THE GOLDEN ARM, by Nelson Algren. 12 14 10 THE MUDLARK, by Theodore Bonnet. 10 18 11 LOVING, by Henry Green. 7 9 12 PRINCE OF EGYPT, by Dorothy Clarke Wilson. 0 2 13 THE DREAM MERCHANTS, by Harold Robbins. 16 8 14 CRY, THE BELOVED COUNTRY, by Alan Paton. 11 24 15 THE SHELTERING SKY, by Paul Bowles. 0 1 16 GYPSY SIXPENCE, by Edison Marshall. 0 7

Add one paragraph mark at top above "1 THE EGYPTIAN, by Mika Waltari. 1 17".

Click the "More" button in find and replace

Check the box "Use wild cards".

Find: ([0-9]{1,2})(*)\, by (*). ([0-9]{1,2}) ([0-9]{1,2})^13

Replace: |-^p|[[\2]]^p|[[\3]]^p|\4^p|\5^p

Find and replace result

|- |[[THE EGYPTIAN]] |[[Mika Waltari]] |1 |17 |- |[[MARY]] |[[Sholem Asch]] |2 |11 |- |[[A RAGE TO LIVE]] |[[John O'Hara]] |3 |18 |- |[[THE WAY WEST]] |[[A.B. Guthrie Jr]] |4 |10 |- |[[ONE ON THE HOUSE]] |[[Mary Lasswell]] |5 |4 |- |[[THE WOMAN OF ROME]] |[[Alberto Moravia]] |6 |6 |- |[[THE BIG FISHERMAN]] |[[Lloyd C. Douglas]] |9 |57 |- |[[LET LOVE COME LAST]] |[[Taylor Caldwell]] |8 |20 |- |[[THE MAN WITH THE GOLDEN ARM]] |[[Nelson Algren]] |12 |14 |- |[[THE MUDLARK]] |[[Theodore Bonnet]] |10 |18 |- |[[LOVING]] |[[Henry Green]] |7 |9 |- |[[PRINCE OF EGYPT]] |[[Dorothy Clarke Wilson]] |0 |2 |- |[[THE DREAM MERCHANTS]] |[[Harold Robbins]] |16 |8 |- |[[CRY, THE BELOVED COUNTRY]] |[[Alan Paton]] |11 |24 |- |[[THE SHELTERING SKY]] |[[Paul Bowles]] |0 |1 |- |[[GYPSY SIXPENCE]] |[[Edison Marshall]] |0 |7

Change ALL CAPS to Title Caps.

Add:

{| class="navbox" align=left style="margin-left:auto; margin-right:auto; width:auto; font-size:90%;"
!Title
!Author
!Last Week
!Week On Lists

...at the top and

|}

...at the bottom.

Ikip (talk) 20:27, 15 November 2009 (UTC)

What's the Point?

What's the point of this if the only lists are for 1950 and 1970? Alphius (talk) 00:19, 29 September 2011 (UTC)

This really isn't even what it claims to be - it doesn't list The New York Times fiction bestsellers; it just lists lists of them (the vast majority of which do not exist). Alphius (talk) 03:28, 30 September 2011 (UTC)

Mobile

The list of years is not visible from a mobile browser. 203.173.250.166 (talk) 01:00, 30 December 2017 (UTC)