np, anytime I need to verify something i'm using psoug :)
and here you have all regular expression
http://www.psoug.org/reference/regexp.html
btw - sorry for posting replay twice
On Dec 1, 9:25 am, Andrej Hopko <ado.ho...@gmail.com> wrote:
> Pawel:
> thanks for working example - I found this function for regexping but I
> didn't have a clue that two sets of [] are needed - I used only one with
> no effect
>
> Niraj:
> this is what you want (Pawels solution customized for yout demands on
> result):
> SELECT REGEXP_REPLACE('OR%^$&*AC&^LE','[[:alnum:]]','')
> FROM dual;
>
> hoppo
>
> On 30.11.2009 9:29, Paweł Pasieka wrote:
>
>
>
> > Hi, with regular expression is easier, this replace all characters
> > except alphanumeric one
> > SELECT /*+FIRST_ROWS */ REGEXP_REPLACE('OR%^$&*AC&^LE','[^[:alpha:]]')
> > FROM dual
>
> > On Mon, Nov 30, 2009 at 8:50 AM, Andrej Hopko <ado.ho...@gmail.com
> > <mailto:ado.ho...@gmail.com>> wrote:
>
> > I made this on to work:
>
> > SET SERVEROUTPUT ON;
> > DECLARE
> > v_word VARCHAR2(30) := 'OR%^$&*AC&^LE';
> > v_out VARCHAR2(30) := '';
> > v_chr VARCHAR2(1);
> > BEGIN
> > FOR i IN 1..length(v_word)
> > LOOP
> > v_chr := SUBSTR(v_word,i,1);
> > IF v_chr BETWEEN 'A' AND 'Z' THEN
> > v_out := v_out || v_chr;
> > END IF;
> > IF v_chr BETWEEN 'a' AND 'z' THEN
> > v_out := v_out || v_chr;
> > END IF;
> > IF v_chr BETWEEN '0' AND '9' THEN
> > v_out := v_out || v_chr;
> > END IF;
> > END LOOP;
> > DBMS_OUTPUT.PUT_LINE(v_out);
> > END;
> > /
> > SET SERVEROUTPUT OFF;
>
> > tried also regular expressions but not enough time to play ;-)
>
> > hoppo
>
> > On 30.11.2009 8:22, Niraj Singh The King wrote:
> > > Please help me in providing a sample code to remove special
> > characters
> > > from a string
>
> > > For E.g if i give string "OR%^$&*AC&^LE" the o/p should be "ORACLE"
> > > --
> > > Thanks and Regards,
> > > Niraj Singh Parihar
> > > Mobile Number : +919890492566.
>
> > > --
> > > You received this message because you are subscribed to the Google
> > > Groups "Oracle PL/SQL" group.
> > > To post to this group, send email to
> > Oracle-PLSQL@googlegroups.com <mailto:Oracle-PLSQL@googlegroups.com>
> > > To unsubscribe from this group, send email to
> > > oracle-plsql-unsubscr...@googlegroups.com
> > <mailto:oracle-plsql-unsubscr...@googlegroups.com>
> > > For more options, visit this group at
> > >http://groups.google.com/group/Oracle-PLSQL?hl=en
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Oracle PL/SQL" group.
> > To post to this group, send email to Oracle-PLSQL@googlegroups.com
> > <mailto:Oracle-PLSQL@googlegroups.com>
> > To unsubscribe from this group, send email to
> > oracle-plsql-unsubscr...@googlegroups.com
> > <mailto:oracle-plsql-unsubscr...@googlegroups.com>
> > For more options, visit this group at
> > http://groups.google.com/group/Oracle-PLSQL?hl=en
>
> > --
> > Paweł Pasieka
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Oracle PL/SQL" group.
> > To post to this group, send email to Oracle-PLSQL@googlegroups.com
> > To unsubscribe from this group, send email to
> > oracle-plsql-unsubscr...@googlegroups.com
> > For more options, visit this group at
> >http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
