Re: how to allow only alphabets in text item?
From: DanHW <danhw_at_aol.com>
Date: 25 Mar 1999 04:46:45 GMT
Message-ID: <19990324234645.01089.00001029_at_ng-fw1.aol.com>
Date: 25 Mar 1999 04:46:45 GMT
Message-ID: <19990324234645.01089.00001029_at_ng-fw1.aol.com>
>hi anyone,
> how to allow only alphabets to be entered into text-item? Is there a
>format mask or you have to filter using trigger?
>
>
>
You can also use the REPLACE function (maybe it is the TRANSLATE, I always need to look it up). It replaces every occurance of one character with the other. For example
x := 'AFGD';
y := translate(x,'ABCDEFGHI','123456789')
would give y='1674'
using this ...
if x = translate(x,'0123456789','XXXXXXXXX') is true, then there are none of the character 0-9 in the string (if there were, they would have been replaced by 'X', and the resulting string would not match the original string.
Hope this helps
Dan Hekimian-Williams Received on Thu Mar 25 1999 - 05:46:45 CET