StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Depending on what sort of real life irregularities you want to find or correct this problem is radically different.</p> <p>Here is your example updated with real text:</p> <pre><code>1. Lazarus Long, Get the first shot off fast. 2. Hiro Protagonist, Greatest swordfighter[sic] in the world. 3. Alice , Down the rabbit hole. 5. Orem, Sink of power. </code></pre> <p>In this example the errors could be fixed with a decent text editor with find an replace. Text editors and hex editors can work miracles if you get creative with wildcards. The problem remains simple as long as your delimiting factors are in existence (. or ,). As you have probably already know; as soon as one of those is missing the problem becomes much more complex. </p> <p>Example of a hard problem:</p> <pre><code>1. Lazarus Long, Get the first shot off fast. 2. Hiro Protagonist Greatest swordfighter[sic] in the world. 3. Alice , Down the rabbit hole. 5 . Orem, , Sink of power. </code></pre> <p>I would probably attack this in a few steps. 1. Clean up extra spaces. 2. Find out key statistics such as the number of delimiters per line and the avg number of words or characters per delimited column. Most names are one or two words, comments are unknown or limited by input. 3. Find lines with a statistically improbably number of key features. 4. Try your best to correct them.</p> <p>I understand that this is not directly solving your problem, but maybe one idea can patch your problem over for a bit. It is possible that past wheel wrights never completed any designs.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload