PS Query & SQL

 View Only

  • 1.  PS Query finding non-alphanumeric data

    Posted 3 days ago

    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
    ------------------------------
    Alliance 2026 Registration is Open!


  • 2.  RE: PS Query finding non-alphanumeric data

    Posted 3 days ago

    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.
    ------------------------------

    Original Message
    Alliance 2026 Registration is Open!


  • 3.  RE: PS Query finding non-alphanumeric data

    Posted 2 days ago

    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
    ------------------------------

    Original Message
    Alliance 2026 Registration is Open!


Related Content