Match a part of text

AppSheet AppSheet Q&A
, ,
1

hello guys
I have two tables
The first table contains column [code1], which contains a code, for example
ab-ss-pt
ab-ss-pt-l2
ab-ws-pr-l1
ab-ws-pr
The second table contains column [code2] containing code, for example
ab-ss-pt-l1-3526 = ab-ss-pt
ab-ws-pr-l1-3566 = ab-ws-pr-l1
ab-ss-pt-l1-7885 = ab-ss-pt
ab-ss-pt = ab-ss-pt
ab-ss-pt-l2 = ab-ss-pt-l2
ab-ss-pt-l1 = ab-ss-pt

What I want is to create a [matching] column in the second table that searches for the code in column [code2] with column [code1] in the first table, and get the code is closest.

thanx

2

Don’t know your whole data in Table1, but with a virtual column the formula could be something like..
INDEX(SORT(SELECT(Table1[Code1],CONTAINS([_THISROW].[Code2],[Code1])),TRUE),1)

2 Likes
3

Thank you very much, it worked successfully

4

Good to hear!