Matching a string variable to any item in a column of an extracted data table

Hi Forum,

I have a task within my bot that I’m stuck on. My goal is to grab a string variable from a website using the get text activity, then compare that string variable to a column in a data table and return true or false if the variable mostly matches an item on the list.

For example, I might pull a few different string values from a website such as (McDonald’s, mcdonalds, mcdonald, etc…) But on my datatable I would only have McDonald’s. So I want to be able to return true by matching “mcdonald” to the “Mcdonald’s” value on my list. Would I use some kind of regex, or fuzzy match activity for this?

Any help greatly appreciated.

Thanks!

Hello @Kyle_Peterson

Welcome to forums

Check my below Posts for your reference

https://forum.uipath.com/t/tutorial-how-to-check-a-string-is-present-in-excel-sheet-part-1/243696/2

https://forum.uipath.com/t/tutorial-another-way-to-check-the-string-is-present-in-excel-or-not/245464/2

You can use Contains instead of equal

Mark as solution if this helps

Thanks

This mostly solved my problem! I incorporated a VBA function to fuzzy match an input, and then I’ll have UIpath take the output back to the website.

Thanks!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.