Hi,

[chaitra Krishnamurthy]

How to write a code for Comparing string to get percentage similarity of 2 strings, looking forward for help.

 

[ewilson]

@chaitra Krishnamurthy ,

See the article at the link below. You can recreate this in a Code stage within a VBO.

https://social.technet.microsoft.co...ating-percentage-similarity-of-2-strings.aspx

I almost forgot, there's also an approximate matching example on the Digital Exchange. I'm not sure that it does exactly what you're looking for, but it might get you started.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/approximate-matching---process-ex

Cheers,
Eric

 

[tgundhus]

I suggest using the "Levenshtein distance" string metric and convert it into a percentage.

Let me know if you need help writing the code, or have any questions.

 

[chaitra Krishnamurthy]

I suggest using the "Levenshtein distance" string metric and convert it into a percentage.

Let me know if you need help writing the code, or have any questions.

Thanks for your reply, but this will not work for me because it will give the difference between 2 sequence not the strings

requirement example:1) S1: Chaitra Murthy
S2: Murthy Chaitra Match percentage = 100%

2) S1: Chaitra
S2: Murthy Chai Match percentage = 28.57%