Re: SUBSTRING FUNCTION IN FORMS 3.0

In article <1992Aug13.081954.279_at_falcon.navsses.navy.mil>, mdipilla_at_falcon.navsses.navy.mil writes:
> TO WHOMOVER KNOWS WHATEVER,
>
> WOULD ANYONE KNOW IF THERE IS A SUBSTRING FUNCTION IN FORMS.
> WE BASICALLY HAVE A FIELD WHICH THE USER WOULD INPUT. HE WILL BE
> TYPING IN A "-" SOMEWHERE IN HIS FIELD. IT CAN BE IN THE THIRD POSITION
> XX-XXXX OR IT CAN BE IN THE FOURTH POSITION XXX-XXXX. HOW CAN I REMOVE
> THIS HYPHEN.
>
> THANK YOUR VERY MUCH
Create a Trigger (POST-CHANGE, POST-FIELD or ON-VALIDATE-FIELD) ..

• Forms V3

IF :Field != REPLACE(:Field,'-','') THEN

   :Field := REPLACE(:Field,'-','');
END IF;

• Forms V2

  SELECT REPLACE(:Field,'-','') INTO :Field     FROM dual
   WHERE REPLACE(:Field,'-','') != :Field

or if you have ORACLE V5 you can take TRANSLATE instad of REPLACE for one character.

-- 

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m_at_bmwf1f.bmwf.gv.at   |
 Bangkasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================