Note: Supports US English text only.
soundex( text )
Returns the soundex code, used to render similar sounding names via phonetic similarities into identical four (4) character codes.
Keyword | Type | Description |
---|---|---|
|
Text |
The text to be converted. |
Text
The soundex code is all uppercase. The first character is retained. From the remainder, vowels are dropped.
Repeated letters are made into single letters.
"BFPV" are coded as "1", "CGJKQSXZ"] as "2","DT" as "3", "L" as "4", "MN" as "5", and "R" as "6" and unfilled characters are "0". For example, "Sullivan" and "Suliban" are both "S415". "Smith" and "Smythe" are both "S530".
soundex("John Smith")
returns J525
Feature | Compatibility | Note |
---|---|---|
Portals | Compatible | |
Offline Mobile | Compatible | |
Sync-Time Custom Record Fields | Compatible | Can be used to create a custom record field that only evaluates at sync time. |
Real-Time Custom Record Fields | Incompatible | |
Process Reports | Compatible | |
Process Events | Compatible |
soundex() Function