Examples

Standard Usage

Example 1:

SORTNORMALIZE("1744-4812 Main St., Anywhere, USA")

yields

"USA ST MAIN ANYWHERE 4812 1744"

Example 2:

SORTNORMALIZE("1744 - 4812 Main Street, Anywhere, USA")

yields

"USA STREET MAIN ANYWHERE 4812 1744"

Example 3:

SORTNORMALIZE("177 Rué Paris")

yields

"RUE PARIS 177"

Specifying a Substitution File

For detailed examples of using a substitution file, see the NORMALIZE() function examples section titled Specifying a Substitution File.

Specifying Extra Characters

For detailed examples of specifying extra characters, see the NORMALIZE() function examples section titled Specifying Extra Characters.