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

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

ValuationError_20200217 - Test.csv

Help

Fuzzy Match

Accepted answers

mwindeler

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

Contains2.yxmd

All comments

mwindeler

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

Contains.yxmd

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

Example1.PNG

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

get_number.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703