SELECT td_url,
  regexp_extract(td_url,'out_splunk$|out_file$|out_forward$|out_secure_forward$|out_exec$|out_exec_filter$|out_copy$') AS pat1,
  regexp_extract(td_url,'out_.*$') AS pat2
FROM access_log
WHERE regexp_extract(td_url,'out_splunk$|out_file$|out_forward$|out_secure_forward$|out_exec$|out_exec_filter$|out_copy$') IS NOT NULL
LIMIT 10