Project and Portfolio Management Practitioners Forum
cancel

Restrict input of special characters and allow only alphabets

Highlighted
Tarun Paul
Respected Contributor.

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
Acclaimed 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
Respected Contributor.

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
Acclaimed 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