Needing help matching similar data from 2 tables to create new column

[Xbit27]

Hello,

   I am trying to match data in one table column that contains a 3 and sometimes 4 digit value with another table column in another table that contains the same nuemeric value with leading text "prd" along with some other identifiers that are tags which are comma seperated.

Identifier looking for: prd_903 

Here is what i have tried however, it isnt returning the full nermeric value properly and i'm not sure what i am doing wrong:

identifier = FIND("prd",'prd'[id], 3, Blank())
when the match goes into the new column...I am only getting "03" as an example of what should be 903

I have tried starting at a differnt place (i.e. 2, or 4) to see if it made a differnce but, it doesnt seem to.

Any help appreciated

[v-jingzhang · Accepted solution]

Hi @Xbit27 

Add a custom column with below code. Then change this new column to Number data type. Use it for further matching. 

Text.Select([Column1], {"0".."9"})

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!