Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Example Original Text :
My Email is Tim.Kimball@amazon.com. Please Contact. I need to replace any email address or this could be Tim.Kimball@anydomain.net like below.
Desire Replace Text:
My Email is Tim.Kimball****. Please Contact. I need to replace any email address or this could be Tim.Kimball**** like below.
I Tried:
replace(subfield('Tim.Kimball@amazon.com', '@', 1), '.', ' ')
But getting
My Email is Tim.Kimball****.
Hi Bionic,
I don't understand what you are trying to do.
Bill
you could try with the RegExReplace examples to be found e.g. here:
https://community.qlik.com/t5/QlikView-App-Dev/Regular-expression-A-Z/td-p/851408
https://community.qlik.com/t5/QlikView-Documents/How-to-use-regular-expressions/ta-p/1477236
http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/
https://community.qlik.com/t5/QlikView-App-Dev/Replacing-Text-using-Wildcards/td-p/278923