NATO Phonetic Alphabet

[glenr]

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

[glenr]

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

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

[comment]

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

)

)

[glenr]

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.