Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Multiple substitutions


Recommended Posts

I have a database of biological names (genera and species) that requires some uniform modifications of European vowels to English vowels.


This is easy to do for any one type of substitution: all I need to do is enter (for example): Substitute(Assigned Genus, "Å“", "oe"), and "CÅ“locaulus" becomes "Coelocaulus."


The problem is that there are numerous vowels that need modification: œ, ü, ø, etc. I have not been able to construct an argument where FileMaker will replace any and all of those archaic vowels with the modern spellings. That is, I want a command (or set of commands) that will convert "Cœlocaulus" to "Coelocaulus" in one entry and "Rüdemannia" to "Ruedemannia" in another entry of the same field.




(P.S. - I did a search for this and came up empty - I apologize if this has been discussed before.)

Link to comment
Share on other sites

Thanks! So, I used:

Substitute(Substitute(Substitute(Genus, "æ", "ae"), "œ", "oe"),"ü","ue") and it now replaces all those funky Euro-vowels with modern spellings!

Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use