Note: Supports US English text only.
FunctionCopy link to clipboard
soundex( text )
Returns the soundex code, used to render similar sounding names via phonetic similarities into identical four (4) character codes.
ParametersCopy link to clipboard
| Keyword | Type | Description |
|---|---|---|
|
|
Text |
The text to be converted. |
ReturnsCopy link to clipboard
Text
Usage considerationsCopy link to clipboard
Understanding resultsCopy link to clipboard
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".
ExamplesCopy link to clipboard
soundex("John Smith") returns J525
Feature compatibilityCopy link to clipboard
The table below lists this function's compatibility with various features in Appian.
| 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 | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
| Process Reports | Compatible | |
| Process Events | Compatible | |
| Process Autoscaling | Compatible |