ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Enhance DecomposeUnicodeForMatch: Add German support an a non-case-changing version

DecomposeUnicodeForMatch removes diacritics and changes the case to lower case which is in deed useful for comparing strings.

 

I have two proposals:

 

Add support for German and other languages

 

In German language, umlauts are replaced by the character + an "e" rather than just removing the dots, i.e., "ä" → "ae", "ö" → "oe", etc. And, the sharp s (sz ligature) is replaced by "ss": "ß" → "ss". Both replacements are not being done by DecomposeUnicodeForMatch.

Proposal: Add an optional argument:

 

DecomposeUnicodeForMatch([String], [Language] = "default")

 

if [Language] = "default" or omitted, standard behaviour is selected.

if [Language] = "de" or "German", replacements "ä" → "ae", "ö" → "oe", "ß" → "ss" etc. are applied

 

Other new replacements would be good, e.g. for "Œ", "œ", "Ø", "ø", "Æ", "æ", e.g., for Danish or French. Native speakers should advice the correct replacements.

 

Switch off case change

 

A second optional argument could be added to switch off the case change and to preserve uppercase characters:

DecomposeUnicodeForMatch([String], [Language] = "default", [Preserve Case] = 0)