Main      Site Guide    
Message Forum
Re: An experiment with the dialectizer
Posted By: MistyCat, on host 203.109.169.9
Date: Thursday, April 6, 2006, at 19:54:40
In Reply To: Re: An experiment with the dialectizer posted by Howard on Thursday, April 6, 2006, at 11:49:57:

<snip>
>
> It only took me 45 minutes to read that. Does anybody want to try to beat my record???
> Howard

Step 1: Copy text to file (Howard.txt.)
Step 2: Search/Replace the exclamation mark with Linefeed.
Step 3: Link to textfile in MSAccess
Step 4: Create this SQL:

SELECT Howard.Field1,
Count(Howard.Field1) AS CountOfField1
FROM Howard
GROUP BY Howard.Field1
ORDER BY Count(Howard.Field1) DESC;

Here's the result, showing the number of times each phrase ending with a bang (that's an exclamation point) appears in the original. :

Field1 CountOfField1
Right on 420
Fry mah 'ide 106
Oi 49
Right 42
Strud 34
Blimey 31
Honest guv 25
'oness guv 6
ah's a-gonnan 'elter-skelta' dis sentence drough d' dialeckiza' 'amma' an' tack an' fo'd drough redneck, right, JIBE, right, right, right, an' cockney 1

Total time spent: About a minute. (I've done that sort of thing many times, and I was working in MSAccess at the time.)

Misty"Let's hear it for Creative Laziness"Cat

Replies To This Message

Post a Reply

RinkChat Username:
Password:
Email: (optional)
Subject:
Message:
Link URL: (optional)
Link Title: (optional)

Make sure you read our message forum policy before posting.