Fuzzy Matching with Variable Input Field

[jconstantine3rd]

I have an application that is essentially a flat table. The columns are name, user_id, company, city, state. I want users to be able to input a list of names in the variable input and then fuzzy match those names with the names in my data set. I believe there isnt an actual tool but would love a creative way someone solved this problem

[mpc]

Hi, 

Fuzzy search sorts the data, so perform a selection with it'll select all the data. 
If you want to do it with, as an alternative, joker char *, you can:

• Create a variable
• Create an input box, set the variable
• Ask your user to enter value, separated by comma
• Create a action button, with action "Select values matchin search string"
• Use an expression like this: =$(=chr(39))$(=Replace('(*$(vFuzzyNameSearch)*)',',','*|*'))$(=chr(39))

Updating Media

Kind regards