how to accept mutiple formats for inputing?

where are you doing your processing?  Inside the form? or in pl/sql on the server?

8i isn't a forms version,  they went from 6i to 9i and 10g.

If your database is 8i

then try this...

 your_field :=
        TRANSLATE(
            your_field,
            '0123456789' || TRANSLATE(your_field, CHR(0) || '0123456789', CHR(0)),
            '0123456789'
        );

Select allOpen in new window

where I put this code to? under the Find button trigger or ...
The form version is 11.0.0

the field is license_number

Here is the image
find-download.JPG

wherever you want.  You could put it behind the find button, if you pass the string to a pl/sql procedure, you could put the code inside that procedure, you could pass it to a function get the stripped string back and pass that to whatever you want.

I have the following error

Compiling WHEN-BUTTON-PRESSED trigger on FIND item in FIND_DOWNLOADS block...
Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in FIND_DOWNLOADS
block:
PL/SQL ERROR 303 at line 6, column 1
qualifier 'FIND_DOWNLOADS' must be declared
PL/SQL ERROR 0 at line 6, column 1
Statement ignored


attached the code is for Find button (when-button-pressed)

:parameter.G_query_find := 'TRUE';
app_find.find('XX_DOWNLOADS_V');
:parameter.G_query_find := 'FALSE';
 
 
find_downloads.license_number :=
        TRANSLATE(
            license_number,
            '0123456789' || TRANSLATE(your_field, CHR(0) || '0123456789', CHR(0)),
            '0123456789'
        );

Select allOpen in new window

any ideas?

I have the following code dealt with the same issue in other form. I don't know how to make an arrangment for it. Can you modify it and where it put to if you don't have any ideas.

    -- This will allow users to query by license numbers including the L or -
   
	IF :find_downloads.license_number IS NOT NULL THEN
        IF INSTR(:find_downloads.license_number,'L',1) > 0 OR INSTR(:find_downloads.license_number,'-',1)  > 0 THEN
	    :find_downloads.license_number := REPLACE(REPLACE(:find_downloads.license_number,'L',''),'-','');
        END IF;
        END IF;
 
 
 
    IF :parameter.G_query_find = 'TRUE' THEN      
       
        IF :find_downloads.license_number IS NOT NULL THEN
	    IF v_where_clause IS NULL THEN
	        v_where_clause := v_where_clause ||'license_number= '||replace(replace(:find_downloads.license_number,'L',''),'-','');
	    ELSE
	        v_where_clause := v_where_clause ||' and license_number= '||replace(replace(:find_downloads.license_number,'L',''),'-','');
	    END IF;
        END IF;
 
     END IF; 

Select allOpen in new window

excellent

glad I could help