topic Re: change name to * in QlikView https://community.qlik.com/t5/QlikView/change-name-to/m-p/1258753#M625887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check this</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14805651073542078" jivemacro_uid="_14805651073542078"> <P>Left(Name,3) &amp; Repeat('*',Len(Name)-3) as New</P> </PRE><P></P><P><IMG __jive_id="145391" alt="Name Replace -241638.PNG" class="jive-image image-1" src="/legacyfs/online/145391_Name Replace -241638.PNG" style="height: auto; width: auto;" /></P><P></P><P></P><P>-Hirish</P></BODY></HTML> Thu, 01 Dec 2016 04:05:19 GMT HirisH_V7 2016-12-01T04:05:19Z change name to * https://community.qlik.com/t5/QlikView/change-name-to/m-p/1258752#M625886 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to change the Name start from the 4th Char with *, is there any way to do that?</P><P>for Example :</P><P>Name :<SPAN style="font-size: 10pt;">MICHAEL JACKSON</SPAN></P><P><SPAN style="font-size: 10pt;">New Name : MIC************</SPAN></P><P></P><P>Thanks</P></BODY></HTML> Thu, 01 Dec 2016 03:40:04 GMT https://community.qlik.com/t5/QlikView/change-name-to/m-p/1258752#M625886 d4rlie891 2016-12-01T03:40:04Z Re: change name to * https://community.qlik.com/t5/QlikView/change-name-to/m-p/1258753#M625887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check this</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14805651073542078" jivemacro_uid="_14805651073542078"> <P>Left(Name,3) &amp; Repeat('*',Len(Name)-3) as New</P> </PRE><P></P><P><IMG __jive_id="145391" alt="Name Replace -241638.PNG" class="jive-image image-1" src="/legacyfs/online/145391_Name Replace -241638.PNG" style="height: auto; width: auto;" /></P><P></P><P></P><P>-Hirish</P></BODY></HTML> Thu, 01 Dec 2016 04:05:19 GMT https://community.qlik.com/t5/QlikView/change-name-to/m-p/1258753#M625887 HirisH_V7 2016-12-01T04:05:19Z Re: change name to * https://community.qlik.com/t5/QlikView/change-name-to/m-p/1258754#M625888 <HTML><HEAD></HEAD><BODY><P>Thank a lot for your Help</P></BODY></HTML> Thu, 01 Dec 2016 04:22:35 GMT https://community.qlik.com/t5/QlikView/change-name-to/m-p/1258754#M625888 d4rlie891 2016-12-01T04:22:35Z