Changing letters in a word using a database - DECODING WORDS

[makiwara]

Hi, I need a code which decodes a word using a database. It's hard to explain, but I will try.

Input in column "E":

LAMP
LAMB
COMPUTER
WORD
WORLD
ALLOW

Code database in Range A1:B44
For example:

LA la
L l
MP mp
MB mb
C c
OMP omp
UTET uter
WOR wor
D d
A a
O o
W w

Output column "F":
lamp
lamb
computer
...

I made an Input List. I want to search the code for each "string" in the database (A1:B44, starting from first cell) and if found in Column "A", store the value of column "B" (with format) in a temporary string. After it, the code "cuts" the found string from the original and search again from codes from A1:B44.

This is an example database, so it's easy to check.

The real one contains data in the database like: A - a51 or B - kdjd or C - ols . So it's irrevelant for us now.

So the program starts by LAMP:
- checks from range A1 to A44:
- LA is found from left to right, so la comes

MB
- checks from range A1 to A44:
- MB is found from left to right, so mb comes

and so on until there is no more character in the word


Thank you for your time! I thought about this project, but it requires some complex part and I am very confused. Have a very nice day!

 

[makiwara]

COMPUTER:
1. code searches for each data in column "A" and finds C--> temp= c
2. remains: OMPUTER
- code searches for each data in column "A" (from the left of OMPUTER to the right)-->
LA found? no.
L found? no.
...
OMP found? YES temp="c" & "omp" ="comp"

3. remains: UTER
- code searches for each data in column "A" (from the left of UTER to the right)-->
- UTER is the only match --> "comp" & "uter" = "computer"

this one is ready, goes to next row in column "E" to the next word.

I hope that I could explain well. Thank you for your help! Have a nice day!

 

[makiwara]

I could solve it, using twice loop through ranges and MID function.