PS Query & SQL

 View Only

How to get rid of pesky characters...

  • 1.  How to get rid of pesky characters...

    Posted 01-22-2025 09:40 AM

    Need to get rid of characters between numbers (like a phone number) 

    REGEXP_REPLACE (I.PHONE, '\D') 

    Remove HTML 

    REGEXP_REPLACE(YOURFIELD,'\s*<[^>]*>\s*',NULL,1,0,'im') 



    ------------------------------
    Steph Zimmerman
    IT Tech Associate
    Illinois State University
    ------------------------------

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