Find and Replace tool

[A121093]

Hello everybody, 

I have the following columns in two separate files:

File 1

File 2

Is it possibile to search string of File 1 in File 2 and have,as output column, all code of of File 2 that CONTAIN the string in File 1? Is it possible to make it through Find and Replace tool? Is it any other way?

Thank you very much in advance.

Kind regards,

Alessandra

[Emil_Kos]

Hi @A121093,

I have prepared a workflow for you using find and replace tool.

[afv2688]

Hello @A121093,

I'm not sure if I did understand what you are looking for.

Could this be it?

Regards

[A121093]

Hello  afv2688,

Yes, it's quite close to the expected result, but I had filter Code column, in File 2 in my example.

Actually this column include also other different code, like in the image I attach.

Kind regards

[Emil_Kos]

Hi @A121093,

In the find and replace tool there is a function to search for any part of the string:

Your final goal is to add a second column from file 2. 

Can you direct me why this isn't working for you?

[A121093]

Hello Emil_Kos,

I added a column in File 2, Code 1, where values are equal to RIGHT(Code;11) and the result is the one in the image below.

Please find below the vlookup setting.

This is the vlookup result, but I need also account S_ACD0*

Maybe I'm doing something wrong?

Kind regards

[afv2688]

Hello @A121093 ,

I did some changes to the code. Let me know if it works now better for you.

Regards