Re: Character String Check

[Chintan Shah]

**

Hi Lisa, You can probably use one of the PATTERN at Field Level. Field has properties where you can do a "Pattern" of either "LOWER" or "UPPER" depending on your scenario. Then you will need an Active Link to validate other special characters. e.g. NOT ('Field' LIKE "%$%") AND NOT ('Field' LIKE "%#%") and so on.. Probably not the best solution..but it might work. Good luck! Thanks Chintan. --- On Tue, 6/14/11, Kemes, Lisa <lisa.ke...@te.com> wrote: From: Kemes, Lisa <lisa.ke...@te.com> Subject: Character String Check To: arslist@ARSLIST.ORG Date: Tuesday, June 14, 2011, 11:30 AM ** I need to check a character field to make sure that the string in the field is alphanumeric and the only special characters that are allowed are a hyphen “-“ or an underscore.  No spaces allowed either.   I’ve tried a bunch of workflow and it’s just not working for me.     Lisa Kemes AR System Developer TE Information Systems Global Infrastructure and Ops +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.com MS 161-43 P.O. Box 3608 Harrisburg, PA 17105-3608 www.te.com   _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_