dbTalk Databases Forums  

Regular Expressions

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Regular Expressions in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
artmerar@yahoo.com
 
Posts: n/a

Default Regular Expressions - 08-06-2008 , 02:56 PM







I'm currently looking for an example on how to code this, but maybe I
can take a shortcut and someone will do it for me. LOL

Anyhow, I need a regular expression to filter out any values with
special characters: !#$%^&*()+=<>,?"':;{}[]|\/

So far I can get the first character to be a valid one:

regexp_like (c1, '(^[A-Z0-9_-])');

I mean, this is really for email address validation. So, there can be
no special characters in it.......I'm still trying things, but, maybe
someone will just give the answer.

Thanks all!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.