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

Overview edit

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 database dump.

Preamble edit

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 edit

This report is generated from a Link Analysis Database using the SQL:

SELECT concat( '*[[', art.art_title, ']] - <nowiki>"', replace(mid( art_text, Locate( ' ,', art_text )-15, 30 ), '\n', ' '), '"</nowiki>' )
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

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 edit

Need to ignore commas in urls to external links.

List edit

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. - TB 17:58, 31 December 2005 (UTC)