Thursday, November 15, 2012 2:24 PM
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?
Tuesday, November 20, 2012 1:05 PM
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
Tuesday, November 20, 2012 3:47 PM
The matching can have optional characters
like 12346789 will match on
12346789 and 123456789or 1234- will accept 1234- and 1234-1234
Wednesday, November 21, 2012 12:47 AM
Thursday, November 29, 2012 2:58 PM
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.
Thursday, November 29, 2012 3:16 PM
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 :-/
- Marked As Answer by Jason H - SQLMicrosoft Employee, Moderator Friday, December 07, 2012 5:29 AM