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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to filter on ASCII characters

Status
Not open for further replies.

jeffreygreen

Technical User
Feb 1, 2012
13
US
COGNOS 8.4

In report studio - I have users that enter a site code, which is supposed to be a 5 character, alpha numeric code. They continue to screw this up. I can filter for Length <5, but I need to filter for characters that are not 0-9 or a-z or A-Z.
Any thoughts of how to do this? I see brackets, plus signs, parentheses, etc. I would rather not keep adding additional characters to my banned list.

The valid ASCII fall into three groups of codes . . .

 
A wild thought.. Why not use 5 prompts that are prepopulated with the relevant ASCII codes (using static choices):

A-Z (26 values)
0-9 (10 values)

and concatenate the selected values to get the final length of 5?

Ties Blom

 
My IT guru decided to TRANSLATE the allowable letters and numbers to " " and then TRIM, I think, and anything over 0 was incorrect . . . thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top