Jump to content

NATO Phonetic Alphabet


glenr
 Share

This topic is 5667 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

)

)

Link to comment
Share on other sites

  • Newbies

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.

Link to comment
Share on other sites

This topic is 5667 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.