Skip to main content

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

Maybe the StringDiacriticRemover from the FME Hub can help?

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


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
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