Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invalid characters

Status
Not open for further replies.
Jun 26, 2002
77
US
I have been asked to provide a report that will display errors for data entry. If the field {{Command.birth_name_last} includes any characters that are not a-z or A-Z or include numbers then I am to display a message. I have tried several methods, but no luck yet. Using Crystal 2008 connected to a Cache data source.

I have tried several different formulas one being:
InStr ({Command.birth_name_last},'[a-zA-Z]')
and nothing seems to work.

Thank you.
 
just quickly looking at your post you should have a , between zA

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top