Android Studio version of an Excel vlookup? -


ok i'm massive noob , apart following lots of tutorials set myself problem , try fix app. therefore i'm trying make little app that'll me when i'm @ work.

basically needs breakdown 4 character string it's individual characters , display them phonetically. if (the user) type in 5f9a it'll display 5 foxtrot 9 alpha. @ work have excel spreadsheet , i'm trying reverse engineer it. spreadsheet has multiple stages, reads characters, converts them ascii , performs vlookup on range of cells each ascii code next it's phonetic pronunciation. looks number 53 (5 in ascii) , looks @ cell next says five.

i've managed translate user input ascii don't know how store , access next set of data. i've been looking sqlite waaaaaay beyond me @ moment , seems far complicated simple?

anyway, know it's cheating asking answer, maybe push in right direction?

the dummy way be:

  • get every letter (char) of word
  • have switch case gives phonetic equivalent (you have hand)

    string word = yourword; string phonetic; char currentchar;

    for(i=0;i<=word.lenth();i++){     currentchar = word.substring(i, i+1);     phonetic = getphonetic(currentchar) }  string getphonetic(char char){     switch char{          case a:              return alpha;              break;          case b: ....      } } 

Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -