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.


Hello @Kyle_Peterson

Welcome to forums

Check my below Posts for your reference

You can use Contains instead of equal

Mark as solution if this helps


1 Like

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.


1 Like

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