Find and Replace not working

[sriniprad08]

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

[binu_acs]

@sriniprad08 One way of doing this

[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?

[ShankerV]

Hi @sriniprad08 

Yes, it is possbile.

But you have value as 0 as first value and all the values in dataset contains 0.

Hence what is the expected output please.

Many thanks

Shanker V

[sriniprad08]

Hi @ShankerV ,

Thank you for the reply. Please find below

[binu_acs · Accepted solution]

@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

[sriniprad08]

Hi @binu_acs ,

Appreciate your help. thank you.

Cheers,

Sri