How to filter Cust name using special char?

casanova · 2014-07-04

hi all
i want to filter cust name started by special char
E.g : %!@#$%^&*)

I use this code, but it wont work..
because field name only 50 chars

CustSpecChar := '`*|~*|!*|@*|#*|$*|%*|^*|&*|(*|)*|_*|-*|+*|=*|{*|[*|}*|]*|\*|:*|;*|<*|,*|>*|.*|?*|/*|0*|1*|2*|3*|4*|5*|6*|7*|8*|9*';
SETFILTER("Name",CustSpecChar);

any idea??

Savatage · 2014-07-04

Have you tried something like this?

..A|Z..

geordie · 2014-07-05

Or check the ASCII code of the first character:

Customer.SETFILTER(Name,'<>%1','');
IF Customer.FINDSET THEN
  REPEAT
    ASCIIValue := Customer.Name[1];
    Customer.MARK((ASCIIValue < 65) OR ((ASCIIValue > 90) AND (ASCIIValue < 97)) OR (ASCIIValue > 122));
  UNTIL Customer.NEXT = 0;

...

How to filter Cust name using special char?

Comments

Categories