Term-Based Relations

Question

I'm setting upp a cleance project and have a domain that need to be cleanced from the sign -.  Is there any 'wild card' setting in the term-Based Relations?

I have tried with all type setting ( % ! ...) but it don't work. 

ex 12345-6774 should result in 123456774,  i have tried even with 5-6 correct to 56 but it did't work.

Is there a solution to this?

Answer 1

I believe you can simply setup a TBR for "-" (single character, no quotes) and leave the "Correct To" field blank.  

Then, from your example (ex 12345-6774 should result in 123456774), as long as 123456774 (no dash) is listed in the domain values for this particular domain, you should find that the TBR strips the "-" from 12345-6774

Answer 2

The matching can have optional characters

like 1234[0]6789 will match on

12346789 and 123456789

or 1234-[0][0][0][0] will accept 1234- and 1234-1234

Answer 3

I believe you can simply setup a TBR for "-" (single character, no quotes) and leave the "Correct To" field blank.  

That should work.

---

Help Others! Don't forget to mark your thread as answered

Answer 4

It don't work with just - in the TBR, that's why I ask for wildcard sign.

The optinal characters will not work since the sign - will be in any place within the data.

Monica

Answer 5

Hi Monica,

In order for the "-" TBR to work, the stripped value needs to already exist in the list of domain values.

So, for example...

Domain Values
1234

Source Values
123-4
67-89

...the "-" TBR will work for source value "123-4", but not for source value "67-89" because 6789 isn't in the list of domain values.  If you add 6789 to the domain values, the TBR should work.

I realize this isn't the same as a wild-card.  You use-case may require preprocessing on source data to handle this.  Unfortunately, DQS is still a release-1 product :-/