Advanced Search

Trim TAB/CR/LF/Space from string

/ Published in: PL/SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT REGEXP_REPLACE(
  2.     'string'
  3.     , '^([[:space:]]|'||CHR(9)||'|'||CHR(10)||'|'||CHR(13)||')+|([[:space:]]|'||CHR(9)||'|'||CHR(10)||'|'||CHR(13)||')+$', '*') AS result
  4.   FROM dual;

Report this snippet


Comments

You need to login to view comments.