remove special characters

Hello, I need to remove the word duplicate from some emails, however this is often accompanied by a period and I cannot remove the period because it would remove the .com for example
duplicate.jesusal@gmail.com I need to keep the .com

Is there ever going to be a case when an email address has a period or hyphen in it?

If not, it may just be easiest to to extract the email addresses and leave everything else behind.

For example, using the Regex Extractor node with the expression [A-Z0-9]+@[A-Z0-9]+\.[A-Z]{3} gives:

image

Alternatively, you could use the String Manipulator node with the expression regexReplace($column1$,"(?i)(.|-)?duplicate(.|-)?" ,"" ) to get the same end result.

5 Likes

Hello, if I am presented with emails with the - for example duplicated-jesus-alv@gmailc.om

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.