Hello everybody,
i want to join two tables. There is sometimes the problem that people has some difficulties to put the string in the right way or add something which is not necessary and when i want to join then the tables its not possible anymore.
For example:
in the System is written Concept Packaging and the people put in the excel just Concept Packagin. Or in the excel is written AD405 v1 and the person put into the system AD405V1 or ADAPCH413 and then in the system will be put ADAPCH413V4. Thats why i try to figure out if there is the possibility to join them regarding a comparison of the letters if they are the same.
I tried it with replace("[name]"," ","") that worked within the space between those numbers but now i have the problem with the whole word.
Maybe there is the possibility that i can just compare the first 6/7 letters.
The joint is not 100% possible. Thats why i wanted to ask if there is a Calculation field which compares just the first 6 letters for example.
Thanks in advance.
