PS Query & SQL

Does anyone have hints on how in PS Query I can find fields that contain characters other than alphanumeric and spaces?

------------------------------
Kevin Shalla
Director of Technology
University of Chicago
------------------------------

You can build an expression like the following:

CASE

WHEN REGEXP_LIKE(A.FIELD, '[^A-Za-z0-9 ]') THEN 'Y'

ELSE 'N'

END

If you use the expression as a field, then you can determine if a field has a character that is not alphanumeric or a space.  Others may have a better way of doing this.

------------------------------
Daniel Labrecque
Oracle Consulting Manager
Huron Consulting Group
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Hi Kevin,

I use this expression to isolate the special characters from a field. It turns alphanumeric characters into spaces and then trims them out:

TRIM(TRANSLATE(UPPER(A.FIELDNAME),'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890',' '))

Then I add that expression as its own field, with criteria that it can't be null, to limit the results to only rows where a special character exists.

I hope this helps!

------------------------------
Sam Kunz
Systems Analyst
Boise State University
samkunz@boisestate.edu
------------------------------