Any ideas on to how to automatically convert a text field into a phonetic word.

Example:

Filemaker = Foxtrot India Lima Echo Mike Alpha Kilo Echo Romeo

I've tried using the Substitute function on this one with no joy whatsoever.

Your help would be very much appreciated !!!

This is a perfect example of what I need to do:

http://www.mousepushers.com/natophoneticapplet.html

I am guessing your problem is with the Substitute() function being case-sensitive (hard to tell what "no joy" means). If so, try:

Trim (

Substitute ( Upper ( text ) ;

[ "A" ; "Alpha " ] ;

[ "B" ; "Bravo " ] ;

...

[ "Z" ; "Zulu " ]

)

)

Thanks 'comment'!

WOW... Hours of tearing my hair out to find I needed to use functions 'Trim' and 'Upper'! What an idiot!

For those that care here is the final calculation:

Trim (

Substitute ( Upper ( text ) ;

[ "A" ; "Alpha " ] ;

[ "B" ; "Bravo " ] ;

[ "C" ; "Charlie " ] ;

[ "D" ; "Delta " ] ;

[ "E" ; "Echo " ] ;

[ "F" ; "Foxtrot " ] ;

[ "G" ; "Golf " ] ;

[ "H" ; "Hotel " ] ;

[ "I" ; "India " ] ;

[ "J" ; "Juliet " ] ;

[ "K" ; "Kilo " ] ;

[ "L" ; "Lima " ] ;

[ "M" ; "Mike " ] ;

[ "N" ; "November " ] ;

[ "O" ; "Oscar " ] ;

[ "P" ; "Papa " ] ;

[ "Q" ; "Quebec " ] ;

[ "R" ; "Romeo " ] ;

[ "S" ; "Sierra " ] ;

[ "T" ; "Tango " ] ;

[ "U" ; "Uniform " ] ;

[ "V" ; "Victor " ] ;

[ "W" ; "Whiskey " ] ;

[ "X" ; "Xray " ] ;

[ "Y" ; "Yankee " ] ;

[ "Z" ; "Zulu " ] ;

[ "0" ; "Zero " ] ;

[ "1" ; "One " ] ;

[ "2" ; "Two " ] ;

[ "3" ; "Three " ] ;

[ "4" ; "Four " ] ;

[ "5" ; "Five " ] ;

[ "6" ; "Six " ] ;

[ "7" ; "Seven " ] ;

[ "8" ; "Eight " ] ;

[ "9" ; "Nine " ]

)

)

I'm using it to display a password phonetically on information sheets we send to customers regarding their hosting. Very handy and will minimise the amount of calls we get regarding misunderstandings over passwords.