partial matching in find replace tool

[huiphocp]

hi all,

I am trying to use find replace tool to find part of a string in a field and append the records of another table to it. I have checked "Case Insensitive Find" and "Any part of Field" but it still doesn't work.

attached a test file.

Thanks

PH

[atcodedog05]

Hi @huiphocp 

Issue in your workflow is The key as Find value should be present in Find within column.

[Qiu]

@huiphocp 
Maybe you should reverse the F and R inputs.

[atcodedog05]

Hi @huiphocp 

Keys 

The highlighted of data is not present in keys

After adding keys

Its able to work like

Another scenario

AB is in ABC so match. But AB in is in ABC123 since and ABC123 is in ABC123 too. That time it will take best match when the configuration is append fields

Hope this helps 🙂

[huiphocp]

thanks all.

lets make it simple.

say there is only 1 row in each table, i want the result but finding "ABC" from "ABC / 123", i can get the result of "003"

[Qiu · Accepted solution]

@huiphocp 
I think mine is doing this.

[huiphocp]

ohhhh thanks. i think you are right. 🙂