Teradata regexp_replace to eliminate specific special characters

regex teradata regexp-replace
Christine Kang picture Christine Kang · Apr 13, 2015 · Viewed 18.3k times · Source

I imported a file that contains email addresses (email_source). I need to join this table to another, using this field but it contains commas (,) and double quotes (") before and after the email address (eg. "[email protected],","). I want to replace all commas and double quotes with a space.

What is the correct syntax in teradata?

Answer

Brian Stephens picture Brian Stephens · Apr 13, 2015

Just do this:

REGEXP_REPLACE(email_source, '[,"]', ' ',1,0,i)

Breakdown:

REGEXP_REPLACE(email_source, -- sourcestring
'[,"]', -- regexp
' ', --replacestring
1, --startposition
0, -- occurrence, 0 = all
'i' -- match -> case insensitive
)

Related questions

Regular expression to match a line that doesn't contain a word

I know it's possible to match a word and then reverse the matches using other tools (e.g. grep -v). However, is it possible to match lines that do not contain a specific word, e.g. hede, using a regular …

Read More
How to validate an email address in JavaScript

Is there a regular expression to validate an email address in JavaScript?

Read More
RegEx match open tags except XHTML self-contained tags

I need to match all of these opening tags: <p> <a href="foo"> But not these: <br /> <hr class="foo" /> I came up with this and wanted to make sure I've got …

Read More