Technical Note: Separating numeric Users from alpha-numeric Users (numbers at end of userID).
Description
Solution
Students: ![a*,b*,c*,d*,e*,f*,g*,h*,i*,j*,k*,l*,m*,n*,o*,p*,q*,r*,s*,t*,u*,v*,w*,x*,y*,z*] - ! removes from criteria each comma separated value within the brackets, then you must comma separate each letter with a wildcard.
Staff: [a*,b*,c*,d*,e*,f*,g*,h*,i*,j*,k*,l*,m*,n*,o*,p*,q*,r*,s*,t*,u*,v*,w*,x*,y*,z*] Brackets include each comma separated value followed by a wild card, which allows numbers to be *AFTER* the indicated letter.
Separating numeric Users from alpha-numeric Users (numbers at end of userID).
Solution
Issue: Customer would like to filter one group of all numeric user ID's from a group of alpha-numeric users:
Example:
Students ID's = ###### (283712)
Staff ID's = @@@@@## (jmiller2)
Staff: [a*,b*,c*,d*,e*,f*,g*,h*,i*,j*,k*,l*,m*,n*,o*,p*,q*,r*,s*,t*,u*,v*,w*,x*,y*,z*] Brackets include each comma separated value followed by a wild card, which allows numbers to be *AFTER* the indicated letter.