Mlarocca: Mlarocca moved page $SNDX to $Sndx: Lower case change

2014-07-29T19:01:18Z

Mlarocca moved page $SNDX to $Sndx: Lower case change

← Older revision	Revision as of 19:01, 29 July 2014
(No difference)

Alex: Automatically generated page update

2013-04-20T13:18:22Z

Automatically generated page update

New page

The $SNDX function returns the SOUNDEX code of an argument. The $SNDX function is commonly used with files containing unusual or frequently misspelled names. You can create a field containing the SOUNDEX code for a name and then use that field for retrievals. 
The code is derived in the following manner: 
<ol>
<li>All consecutive occurrences of the same letter are reduced to a single occurrence.</li>
<li>The first character of the string becomes the first character of the result.</li>
<li>All vowels, special characters, and the letters H, W, and Y are eliminated. The rest of the characters are transformed as follows:</li>
</ol>
<table>
<tr class="head">
<th>Character(s) </th>
<th>Change to...</th>
</tr>
<tr>
<td>B, F, P, V </td>
<td align="right">1</td>
</tr>
<tr>
<td>C, G, J, K, Q, S, X, Z </td>
<td align="right">2</td>
</tr>
<tr>
<td>D, T </td>
<td align="right">3</td>
</tr>
<tr>
<td>L </td>
<td align="right">4</td>
</tr>
<tr>
<td>M, N </td>
<td align="right">5</td>
</tr>
<tr>
<td>R </td>
<td align="right">6 </td>
</tr>
</table>
<ol>
<li>SOUNDEX code assigns numbers to the next three consonants of the word following the number assignments shown in the previous table, but disregards any remaining consonants. The <var class="product">Model 204</var> $SNDX function continues to assign numbers to all consonants.</li>
</ol>
Example 1
$SNDX('MURRAY') equals M6
$SNDX('MARY') equals M6
$SNDX('O"MALLEY') equals O54

Example 2
BEGIN
%A = $SNDX($READ('ENTER NAME'))
FIND.RECS: FIND ALL RECORDS FOR WHICH
NAME SOUND = %A
END FIND
.
.
.

[[Category:SOUL $functions]]

$Sndx - Revision history

Mlarocca: Mlarocca moved page $SNDX to $Sndx: Lower case change

Alex: Automatically generated page update