Donnerstag, 15. November 2012 14:24
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?
Dienstag, 20. November 2012 13:05
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
Dienstag, 20. November 2012 15:47
The matching can have optional characters
like 12346789 will match on
12346789 and 123456789or 1234- will accept 1234- and 1234-1234
Mittwoch, 21. November 2012 00:47
Donnerstag, 29. November 2012 14:58
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.
Donnerstag, 29. November 2012 15:16
In order for the "-" TBR to work, the stripped value needs to already exist in the list of domain values.
So, for example...
...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 :-/
- Als Antwort markiert Jason H - SQLMicrosoft Employee, Moderator Freitag, 7. Dezember 2012 05:29