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