View source for User:Topbanana/Reports/This may have a problem with a comma

== Overview ==

The list below shows articles which contain a comma which is not followed by a space.It was generated on 13th December 2004 from the 26th November 2004 [[Wikipedia:Database_download|database dump]].

== Preamble ==

In English, commas are always followed by spaces.  Unless the articles below are using commas in some special way, they break this rule.  Edit such articles and add spaces after the commas.

== Regenerating this report ==

This report is generated from a [[User:Topbanana/Reports/Scripts/Create Link Analysis Database|Link Analysis Database]] using the SQL:

<pre><nowiki>
SELECT concat( '*[[', art.art_title, ']] - &lt;nowiki&gt;"', replace(mid( art_text, Locate( ' ,', art_text )-15, 30 ), '\n', ' '), '"&lt;/nowiki&gt;' )
FROM art LEFT OUTER JOIN special_text ON Locate( ' ,', art_text ) BETWEEN start AND end AND special_text.art_id = art.art_id
WHERE special_id IS NULL
AND Locate( ' ,', art_text ) > 0
</nowiki></pre>

A number of variations on this are useful - replacing ' ,' with ',a' for example.  The results may need split into subsections by hand.  Excerpts from articles containing special characters may need edited by hand.

== Suggested improvements ==

* Need to ignore commas in urls to external links.

== List ==

----
''This list only covers articles starting with a numeric character or alphabetics A through G to keep its size manageable while it's under development.''
----

List removed, hideously out of date.  - [[User:Topbanana|TB]] 17:58, 31 December 2005 (UTC)