https://community.qlik.com/t5/QlikView/Replacing-Email-Addresses-from-Text/m-p/1933713#M1219076 <P>Hi,</P> <P>Example Original&nbsp; Text :</P> <P>My Email is&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball@amazon.com</A>. Please Contact. I need to replace any email address or this could be&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball@anydomain.net</A> like below.</P> <P>Desire Replace Text:&nbsp;</P> <P>My Email is&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball</A>****. Please Contact. I need to replace any email address or this could be <A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball</A>**** like below.</P> <P>&nbsp;</P> <P>I Tried:</P> <P><SPAN>replace(subfield('</SPAN><STRONG>Tim.Kimball@amazon.com', '@', 1), '.', ' ')</STRONG></P> <P><STRONG>But getting&nbsp;</STRONG></P> <P><STRONG>My Email is&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball</A>****.&nbsp;</STRONG></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 20 May 2022 17:49:40 GMT Bionic 2022-05-20T17:49:40Z https://community.qlik.com/t5/QlikView/Replacing-Email-Addresses-from-Text/m-p/1933713#M1219076 <P>Hi,</P> <P>Example Original&nbsp; Text :</P> <P>My Email is&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball@amazon.com</A>. Please Contact. I need to replace any email address or this could be&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball@anydomain.net</A> like below.</P> <P>Desire Replace Text:&nbsp;</P> <P>My Email is&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball</A>****. Please Contact. I need to replace any email address or this could be <A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball</A>**** like below.</P> <P>&nbsp;</P> <P>I Tried:</P> <P><SPAN>replace(subfield('</SPAN><STRONG>Tim.Kimball@amazon.com', '@', 1), '.', ' ')</STRONG></P> <P><STRONG>But getting&nbsp;</STRONG></P> <P><STRONG>My Email is&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball</A>****.&nbsp;</STRONG></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 20 May 2022 17:49:40 GMT https://community.qlik.com/t5/QlikView/Replacing-Email-Addresses-from-Text/m-p/1933713#M1219076 Bionic 2022-05-20T17:49:40Z https://community.qlik.com/t5/QlikView/Replacing-Email-Addresses-from-Text/m-p/1944218#M1219498 <P>Hi Bionic,</P> <P>I don't understand what you are trying to do.&nbsp;</P> <P>&nbsp;</P> <P>Bill</P> Wed, 15 Jun 2022 19:25:34 GMT https://community.qlik.com/t5/QlikView/Replacing-Email-Addresses-from-Text/m-p/1944218#M1219498 Bill_Britt 2022-06-15T19:25:34Z https://community.qlik.com/t5/QlikView/Replacing-Email-Addresses-from-Text/m-p/1944251#M1219500 <P>you could try with the RegExReplace examples to be found e.g. here:<BR /><BR /><A href="https://community.qlik.com/t5/QlikView-App-Dev/Regular-expression-A-Z/td-p/851408" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Regular-expression-A-Z/td-p/851408</A></P> <P><A href="https://community.qlik.com/t5/QlikView-Documents/How-to-use-regular-expressions/ta-p/1477236" target="_blank">https://community.qlik.com/t5/QlikView-Documents/How-to-use-regular-expressions/ta-p/1477236</A></P> <P><A href="http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/" target="_blank">http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/</A></P> <P><A href="https://community.qlik.com/t5/QlikView-App-Dev/Replacing-Text-using-Wildcards/td-p/278923" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Replacing-Text-using-Wildcards/td-p/278923</A></P> <P>&nbsp;</P> Wed, 15 Jun 2022 21:32:04 GMT https://community.qlik.com/t5/QlikView/Replacing-Email-Addresses-from-Text/m-p/1944251#M1219500 MarcoWedel 2022-06-15T21:32:04Z