Removing accents

[basenotes]

Hi folks - is there any way I can get FM to remove accents and other diacritic marks from characters. ie changing é to e

Regards

Edited March 13, 2006 by Guest

[Kent Searight]

Try:

Substitute (textField; "é"; "e")

[basenotes]

That seems to work fine, thanks. How do I extend it to change other characters?

ie:

Substitute (textField; "é"; "e")

Substitute (textField; "è"; "e")

Substitute (textField; "ü"; "u")

Substitute (textField; "î"; "i")

Substitute (textField; "ä"; "a")

I've tried this and it tells me 'An operator is expected here'

Thanks

[Vaughan]

Nest the substitute functions...

Substitute ( Substitute ( Substitute ( Substitute ( Substitute ( textField ; "é" ; "e") ; "è"; "e") ; "ü" ; "u") ; "î" ; "i") ; "ä" ; "a" )

[basenotes]

Thanks - works a treat