Hi,
here is an example of a list
Here is the final result I would like to achieve:
Thanks,
It isn't obvious are from your question + post that are you looking for most matching characters or closest match as a string (two different things with two different solutions?
For matching strings one of these might help Shortest Edit Script and Choose Closest (scripting index isn't able to get link for help page for this).
Edit:
Link from JMP help Identify Differences Between Strings, Lines, or Sequences (jmp.com)
@jthi I am looking for the closet match as a string from the list. I am aware of the Shortest Edit script index however I am trying to figure out how can I assign the closest match string from the sample list which is randomly sorted
Loop over your list, perform calculation using Shortest Edit Script (or write your own algorithm) for each of the values, pick the one with best match?
What criteria can I use to determine the best match among the strings? "Common" in the SES? Can you share an example?
