topic Re: Replace function with 2 conditions in QlikView https://community.qlik.com/t5/QlikView/Replace-function-with-2-conditions/m-p/463513#M173097 <HTML><HEAD></HEAD><BODY><P>Sorry found another way around it =&nbsp; replace(replace())</P></BODY></HTML> Wed, 17 Apr 2013 14:59:37 GMT 2013-04-17T14:59:37Z Replace function with 2 conditions https://community.qlik.com/t5/QlikView/Replace-function-with-2-conditions/m-p/463512#M173096 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a simple query. When using the replace function in the script.</P><P></P><P>eg. replace(StoreName,'Store','') as StoreName</P><P>Above replaces all StoreNames with the name 'Store' with a blank.</P><P></P><P>What if i need to replace multiple text values. eg. Store and Shop how would i go about it?</P><P></P><P>I have tried replace(StoreName,'Store','Shop','') as StoreName</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; replace(StoreName,('Store','Shop'),'') as StoreName</P><P></P><P>Any ideas or solutions?</P><P></P><P>Regards,</P><P></P><P>Richard</P></BODY></HTML> Wed, 17 Apr 2013 13:10:05 GMT https://community.qlik.com/t5/QlikView/Replace-function-with-2-conditions/m-p/463512#M173096 2013-04-17T13:10:05Z Re: Replace function with 2 conditions https://community.qlik.com/t5/QlikView/Replace-function-with-2-conditions/m-p/463513#M173097 <HTML><HEAD></HEAD><BODY><P>Sorry found another way around it =&nbsp; replace(replace())</P></BODY></HTML> Wed, 17 Apr 2013 14:59:37 GMT https://community.qlik.com/t5/QlikView/Replace-function-with-2-conditions/m-p/463513#M173097 2013-04-17T14:59:37Z