Skip to main content
  • Home
  • Ideas
  • A function that removes diacritics (accents) from strings
Archived

A function that removes diacritics (accents) from strings

Related products:Transformers
siennaatsafe
moberdries
dxirgu
  • siennaatsafe
    siennaatsafe
  • moberdries
    moberdries
  • dxirgu
    dxirgu
moberdries
Contributor

If I have a user that needs to interactively do a Road-Name search then road names containing diacritics will fail the search. The workaround is to have 2 road name attributes, one for searching, and one for publishing. For my Road-Name search attribute, I need to be able to strip out the diacritics.

PostgreSQL offers a "unaccent" function to do this - can we have this same capability inside FME StringReplacer or similar?

Refer https://www.postgresql.org/docs/9.1/static/unaccent.html

This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

david_r
Evangelist
  • david_rEvangelist
  • April 5, 2017

Maybe the StringDiacriticRemover from the FME Hub can help?

https://hub.safe.com/transformers/stringdiacriticremover

bruceharold
Contributor
Forum|alt.badge.img+17
  • bruceharoldContributor
  • Contributor
  • April 6, 2017

Mike, these are Maori macronated vowels in your context aren't they?

You could build something from the attached code or build a streetname locator from the style file in this sample:

 

maori-macrons.py
david_r
Evangelist
  • david_rEvangelist
  • April 7, 2017
For info: I just tried a couple of these macronated vowels with the StringDiacriticRemover and it seems to work:

 

Input: Th? qu?ck brown fox j?mps over the l?zy d?g Output: The quick brown fox jumps over the lazy dog

 

Helpful Members This Week

Community Stats

30,892
Posts
117,078
Replies
38,700
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.