Talend Open Profiler 1.0.0RC1 is released with a few patterns (in "Libraries" folder). These patterns are regular expressions that databases now support (at least recent versions of MySQL and Oracle). They provide you some kind of business indicators that measure your data quality.
You can drag&drop these patterns can be onto selected columns in the editor. This will automatically create an indicator that will show you how much of your data respects your pattern. By a right click on the "Patterns" folder, you are able to create your own patterns (provided you know how to write regular expressions for your database system).
I think that this topic could be a place where you may share your patterns with others. The patterns you provide could also be integrated in a next release of TOP if they are correct and if we think that they are pertinent enough. But the best way to see your pattern integrated into TOP is to fill a feature request at http://talendforge.org/bugs/my_view_page.php