Convert Oracle Regexp_replace function into Netezza

Question

Following Regexp_replace needs to be converted into Netezza Syntax:

regexp_replace(COLUMN_NAME,'([[:cntrl:]])|(^\t)|(\s+$)',null)

From what i understand, cntrl replaces control characters ^\t replaces tabs \s+$ replaces trailing spaces

Please help! Please also correct my understanding of what this current regex does in oracle.

Answer 1

You're almost right.

([[:cntrl:]])|(^\t)|(\s+$)

1. [:cntrl:] — matches control characters
2. \t — matches tab
3. ^\t in between expressions — matches a ^ and tab character together
4. [^\t] in between expressions — matches non-tab characters
5. ^\t at start — matches leading tab characters
6. \s+$ — matches text with trailing spaces

Effectively, your expression will match - first control character, leading tab or trailing spaces.