You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Quality and Talend Enterprise Data Quality » Configuration, usage and feedback
- » Email Pattern in SQL_SERVER table
#1 2009-07-06 15:23:48
- EDICdiscount
- Member
- Registered: 2009-06-26
- Posts: 23
Email Pattern in SQL_SERVER table
Hi,
I'm trying TOP today, it's a very interesting tool.
I want to define a pattern to check validity of email in a sql Server Table. Patterns already exist for MySQL and Oracle but not for MS SQL Server. I tried to duplicate those existing and associate them to MS Sql Server connection type buut it doesn't work.
Can you tell me how can i define a compatible Email pattern to check my email fields in sql server Tables please ?
Thanks a lot.
Offline
#2 2009-07-06 15:34:58
Re: Email Pattern in SQL_SERVER table
Hi,
Currently SQL Server does not provide native support of regular expressions. you must use an external library. See for example http://msdn.microsoft.com/en-us/magazine/cc163473.aspx or http://www.codeproject.com/KB/string/SqlRegEx.aspx
Once a regex function is defined on your server, you can configure TOP to use it in the preference page: "Data Profiler > UDF Preference".
Thank you for your support,
Sebastiao Correia.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Quality and Talend Enterprise Data Quality » Configuration, usage and feedback
- » Email Pattern in SQL_SERVER table