Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

String comparison using regex

1015156Jun 13 2013 — edited Jul 19 2013

I try to develop a string compare with tiny substrings to have a value for similarity.

That is not a problem if you use loops. But I wanted to do so with (recursive) RegEx.

An example:

If I have the two Names 'Indiana Jones' and 'John Dow'. I then want to count these substring which are identically.

next you cut each name in two letter substrings like 'In', 'nd', 'di', 'ia', 'an', 'na', 'Jo', 'on', 'ne', 'es' and 'Jo', 'oh', 'hn', 'Do', 'ow'. Now I want do count the identical substrings out of MAX(COUNT(substrings_name1),COUNT(substrings_name1)). So I have a value for comparison.

Does anybody have an idea how the RegEx have to look like.

Many thanks in advance.

Steffen

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2013
Added on Jun 13 2013
4 comments
3,386 views