Reltio Connect

Hello,

I am trying to flag the records where the data contains all the permutations and combinations of Doctor (like dr. DR. etc).

I have created below regex expression and its giving zero records in return and there are matching records in the database.

(\\W|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(\\W|$)

sample data: 10925 Briar Mills Dr. Apt 2191

------------------------------
Harshada Phadol
Ascension Health
------------------------------

Hi Harshada,

Please try using the below, i was able to get the desired output when i have removed \\W at the beginning & ending of the regex expression.

(\\W|^) and (\\W|$) components are used to match the start/end of a line to ensure that the matched word is not part of a larger word.

Regex used : (|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(|$)

Validated the same sample data with new Regex function through  https://regex101.com/ as well.

Thanks & Regards,

Hello,

I am trying to flag the records where the data contains all the permutations and combinations of Doctor (like dr. DR. etc).

I have created below regex expression and its giving zero records in return and there are matching records in the database.

(\\W|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(\\W|$)

sample data: 10925 Briar Mills Dr. Apt 2191

------------------------------
Harshada Phadol
Ascension Health
------------------------------

Hi Harshada,

Please try using the below, i was able to get the desired output when i have removed \\W at the beginning & ending of the regex expression.

(\\W|^) and (\\W|$) components are used to match the start/end of a line to ensure that the matched word is not part of a larger word.

Regex used : (|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(|$)

Validated the same sample data with new Regex function through  https://regex101.com/ as well.

Thanks & Regards,

Hello,

I am trying to flag the records where the data contains all the permutations and combinations of Doctor (like dr. DR. etc).

I have created below regex expression and its giving zero records in return and there are matching records in the database.

(\\W|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(\\W|$)

sample data: 10925 Briar Mills Dr. Apt 2191

------------------------------
Harshada Phadol
Ascension Health
------------------------------

Hi Harshada,

Please find the below updated function that would help to detect only needed patterns.

Regex used -  (^| )(dr|dr\.|doctor|d\.r\.|drs\.|drs)( |$)
Validated the same sample data as stated above.

Thanks & Regards,
Chetan

Hi Harshada,

Please try using the below, i was able to get the desired output when i have removed \\W at the beginning & ending of the regex expression.

(\\W|^) and (\\W|$) components are used to match the start/end of a line to ensure that the matched word is not part of a larger word.

Regex used : (|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(|$)

Validated the same sample data with new Regex function through  https://regex101.com/ as well.

Thanks & Regards,

Hello,

I am trying to flag the records where the data contains all the permutations and combinations of Doctor (like dr. DR. etc).

I have created below regex expression and its giving zero records in return and there are matching records in the database.

(\\W|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(\\W|$)

sample data: 10925 Briar Mills Dr. Apt 2191

------------------------------
Harshada Phadol
Ascension Health
------------------------------

Hi Chetan

Thank you for your help

I checked the updated expression and it works perfectly on https://regex101.com/ but Reltio returns zero records.

Most of the expressions works with regex101 but there is some problem with Reltio. 

Thanks

Hi Harshada,

Please find the below updated function that would help to detect only needed patterns.

Regex used -  (^| )(dr|dr\.|doctor|d\.r\.|drs\.|drs)( |$)
Validated the same sample data as stated above.

Thanks & Regards,
Chetan

Hi Harshada,

Please try using the below, i was able to get the desired output when i have removed \\W at the beginning & ending of the regex expression.

(\\W|^) and (\\W|$) components are used to match the start/end of a line to ensure that the matched word is not part of a larger word.

Regex used : (|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(|$)

Validated the same sample data with new Regex function through  https://regex101.com/ as well.

Thanks & Regards,

Hello,

I am trying to flag the records where the data contains all the permutations and combinations of Doctor (like dr. DR. etc).

I have created below regex expression and its giving zero records in return and there are matching records in the database.

(\\W|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(\\W|$)

sample data: 10925 Briar Mills Dr. Apt 2191

------------------------------
Harshada Phadol
Ascension Health
------------------------------

Hi Harshada,

Most of my use case match with the output of regex101.com and Reltio.

Let me check implementing the same in Reltio and update you.

Thanks & Regards,

Hi Chetan

Thank you for your help

I checked the updated expression and it works perfectly on https://regex101.com/ but Reltio returns zero records.

Most of the expressions works with regex101 but there is some problem with Reltio. 

Thanks

Hi Harshada,

Please find the below updated function that would help to detect only needed patterns.

Regex used -  (^| )(dr|dr\.|doctor|d\.r\.|drs\.|drs)( |$)
Validated the same sample data as stated above.

Thanks & Regards,
Chetan

Hi Harshada,

Please try using the below, i was able to get the desired output when i have removed \\W at the beginning & ending of the regex expression.

(\\W|^) and (\\W|$) components are used to match the start/end of a line to ensure that the matched word is not part of a larger word.

Regex used : (|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(|$)

Validated the same sample data with new Regex function through  https://regex101.com/ as well.

Thanks & Regards,

------------------------------
Chetan P
Lead MDM Specialist
Freshworks
Chennai

Original Message:
Sent: 06-05-2023 16:05
From: Harshada Phadol
Subject: Reltio Data Validation Functions not working with Regex Expressions

Hello,

I am trying to flag the records where the data contains all the permutations and combinations of Doctor (like dr. DR. etc).

I have created below regex expression and its giving zero records in return and there are matching records in the database.

(\\W|^)(?i)(doctor|dr.|dr|d.r.|drs.|drs)(\\W|$)

sample data: 10925 Briar Mills Dr. Apt 2191

------------------------------
Harshada Phadol
Ascension Health
------------------------------