Any tips on using REGEXP_SUBSTR()? I'm trying to identify lines with non-ascii characters, but can't get the following to work: REGEXP_SUBSTR({memo},'/[^\x00-\x7F]/g')

Hi Corey Looks like you've plugged in a JS regex. Need to do translate into the parameters of the Oracle / PLSQL: REGEXP_SUBSTR Function. flags go into "match_parameter", but the global flag ("g") is redundant, as substr returns the first match only. You also need to drop the JS forward slashes. if you're just identifying lines, you could also the criteria "REGEXP_INSTR(...) > 0"

Thanks, David!