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 Chriss Miller 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.
Joined
Jun 26, 2002
Messages
77
Location
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