Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Restrict input of special characters and allow only alphabets

Highlighted
Tarun Paul
Regular Collector

Restrict input of special characters and allow only alphabets

Hi,

We have a text field in a request type which requires only alphbetic characters(Name- field), do we have any way to restrict the special characters and numbers. I tried with the Custome type(L) in Data Mask but it didn't work. Does anyone have any clue on that.

Thanks,
Tarun11
3 REPLIES
Mahen M
Honored Contributor

Re: Restrict input of special characters and allow only alphabets

Can you write a UI rule which shows a message and prevents users from proceeding?

Regards,
Mahendran M
Tarun Paul
Regular Collector

Re: Restrict input of special characters and allow only alphabets

Thanks for your response.
It would be good if you can provide me with a sample script, thanks for your help.

Tarun11
Jim Esler
Honored Contributor

Re: Restrict input of special characters and allow only alphabets

I used the following to generate a message for a field that allowed an oddball set of characters. The chr functions are used because the rule was not letting me put in [] characters directly.

select 'x',
decode(regexp_instr('[TE.VP.TRANSACTION_ID]',chr(91)||'^A-Z0-9$@#./-_%&?!:|=,;<>'||chr(93)),0,'',' Transaction ID contains invalid characters')
from dual
//Add this to "OnDomLoad" event