Find and Replace not working

Hi Team,

Hope you are well. i am trying for longer and couldnt find a solution.

I need your help

I have two columns i would like to find if List1 is in List 2.

There are difference interms of last few letters. I am trying to use find and replace but not sure which options to choose.

i tried all the below options. Entire list, part of the list and case insensitve,match whole word only. But not sure what i am missing.

I need a column C which says if List1 is in List2.

thanks

Workflow

Parse

Fuzzy Match

Accepted answers

binu_acs

@sriniprad08 Find and Replace tool works only on the string fields, because of that you need to convert your numerical field into a string first then apply the find and replace tool

Find_Repalce_200323.yxmd

All comments

binu_acs

@sriniprad08 One way of doing this

Find_Repalce_200323.yxmd

FrederikE

Hey @sriniprad08,

If you only want to check if one cell is in the other cell you don't need a F&R Tool.

You can just go with a "Contains" function.

sriniprad08

Hi @binu_acs ,

Thank you so much. Appreciate that. Is possible to check with numbers if one is present in another?

sriniprad08

hi @FrederikE ,

Thank you for the help. These are coming from two different files.

is it possible to compare when List1 is from one file and List2 is from another file?

binu_acs

@sriniprad08 Find and Replace tool works only on the string fields, because of that you need to convert your numerical field into a string first then apply the find and replace tool

Find_Repalce_200323.yxmd

sriniprad08

Hi @binu_acs ,

Appreciate your help. thank you.

Cheers,

Sri

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703