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
Post a Comment