saravananravim
New member
- Joined
- Mar 27, 2018
- Messages
- 1
- Programming Experience
- 5-10
[FONT="]Hi[/FONT]
[FONT="][FONT="]I have below Oracle regular expression that validates email-id. I need to convert this into its equivalent regex [/FONT]
[FONT="]that I can use in CLR program in SSIS.[/FONT]
[FONT="]/^(\s*[a-zA-Z0-9_\'-.])@([a-zA-Z0-9_-.]).([a-zA-Z]{2,5})$/[/FONT]
[FONT="]Can someone pls help me convert?[/FONT]
[FONT="]In plain english below is the rule:[/FONT]
[FONT="]1.An email should start with any non-white space character[/FONT]
[FONT="]2. Preceding with zero or more characters from the list of: a-z A-Z 0-9 - _ ' .[/FONT]
[FONT="]3. @(at symbol)[/FONT]
[FONT="]4. Any character from the list of: a-z A-Z 0-9 - _ .[/FONT]
[FONT="]5. .(dot symbol)[/FONT]
[FONT="]6. Any character from the list of: a-z A-Z between the size of 2 to 5 characters.[/FONT][/FONT]
[FONT="][FONT="]I have below Oracle regular expression that validates email-id. I need to convert this into its equivalent regex [/FONT]
[FONT="]that I can use in CLR program in SSIS.[/FONT]
[FONT="]/^(\s*[a-zA-Z0-9_\'-.])@([a-zA-Z0-9_-.]).([a-zA-Z]{2,5})$/[/FONT]
[FONT="]Can someone pls help me convert?[/FONT]
[FONT="]In plain english below is the rule:[/FONT]
[FONT="]1.An email should start with any non-white space character[/FONT]
[FONT="]2. Preceding with zero or more characters from the list of: a-z A-Z 0-9 - _ ' .[/FONT]
[FONT="]3. @(at symbol)[/FONT]
[FONT="]4. Any character from the list of: a-z A-Z 0-9 - _ .[/FONT]
[FONT="]5. .(dot symbol)[/FONT]
[FONT="]6. Any character from the list of: a-z A-Z between the size of 2 to 5 characters.[/FONT][/FONT]