How to search for a string in one column within another and produce results in a third

[RDodger]

Hi,

I am trying to seatch for the Instrument TIC in Column B within the string on Column A. Then if found return the full text within Column A in a new Column C

Can you help?

Thanks,

Roger

[mwindeler]

You can use the contains expression to search for strings within fields.

[RDodger]

Hey,

Thanks for the quick response.

That query works but I need to actually search the whole population of column A to find if a cell contains Column B rather than the adjoining Cell in each row.

How could I do that ?

Thanks,

Roger

[afv2688]

Hello @RDodger,

In my case I used a regex tool to be able to better see both numbers:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[mwindeler · Accepted solution]

You can split into two columns and feed into either inputs of the find/replace tool.

[afv2688]

Changed the logic based on your new post @RDodger 

You can check it again now

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[RDodger]

That worked. thanks a lot!!