Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Bionic
		
			Bionic
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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****.
 
					
				
		
.png) Bill_Britt
		
			Bill_Britt
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Bionic,
I don't understand what you are trying to do.
Bill
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
