Topic: Pattern Finder
Pattern Finder
Hi Guys
When I run a pattern analyser on a column with mobile numbers it identifies 0119053210 and 111 as pattern 9999999999 which is probably by design. Is there a way to identify 0119053120 as 9999999999 and 111 as 999?
Kind Regards
Wayne
When I run a pattern analyser on a column with mobile numbers it identifies 0119053210 and 111 as pattern 9999999999 which is probably by design. Is there a way to identify 0119053120 as 9999999999 and 111 as 999?
Kind Regards
Wayne
Hi Wayne,
No :) But it is a reasonable request so I will add a feature request report on it.
What you might do is use a "String length" transformer which will give you the length of each value. But that is of course assuming that all values only have numbers, because otherwise you would find even more patterns like "aaaa999".
No :) But it is a reasonable request so I will add a feature request report on it.
What you might do is use a "String length" transformer which will give you the length of each value. But that is of course assuming that all values only have numbers, because otherwise you would find even more patterns like "aaaa999".
Hi Kasper
I have done just that. :-) Thats for logging the feature request.
Kind Regards
Wayne
I have done just that. :-) Thats for logging the feature request.
Kind Regards
Wayne
Log in by clicking the login link at the top of the screen
Go back to forum.
