Find and Replace Tool for Contains

[BobbyQ]

Trying to figure out why Find and Replace isn't working. I've attached the workbook. My only guess is the hyphen is the issue? Essentially I want Electric Company-Consignment as the final result in Right_NAME. Any help would be greatly appreciated. 

[Hsandness]

You're not getting the desired output because the Find and Replace tool just replaces the found text, not the entire field which is why you still have Scrap Charge at the end of the Right_Name output. If you know that only Scrap Charge is going to be at the end of the text you could update the Find and Replace tool to look for that entire name like I've done in the attached workflow but at that point I would use a filter or join instead.

[alexnajm]

What are you trying to Replace with? I don't see a second column indicating what to replace with once it finds a match

[BobbyQ]

Got it. The issue is there are multiple companies that have varying length that I would need to match on withing the column. I couldn't think of a way to parse the data to join on as I need almost a contains in the join itself. I need to figure out a way to match the name from one table to another tables column that contains part of that string I need to match to.

[BobbyQ]

Replacing Right_NAME with Account_Name

[Hsandness]

Depending on how many companies there are you could hardcode them into a RegEx tool for each possible company like in the screenshot. Another option that would be more dynamic is to append the Replacement field onto the record and either replace its value for the Right_Name field or just rename the Replacement field to Right_Name like I did in the updated Solution 1 container.