https://community.qlik.com/t5/QlikView/Replace-values-in-a-variable-length-field/m-p/1648845#M730664 <P>hi all</P><P>&nbsp;</P><P>I have a variable length field, lets call it AcNum, I want to ONLY keep the first 4 characters of the string and replace the rest with '*'</P><P>So...</P><P>abcd789 would become abcd*** and</P><P>asdfghjk will become asdf****</P><P>Thank you</P> Sat, 16 Nov 2024 19:38:10 GMT QFanatic 2024-11-16T19:38:10Z https://community.qlik.com/t5/QlikView/Replace-values-in-a-variable-length-field/m-p/1648845#M730664 <P>hi all</P><P>&nbsp;</P><P>I have a variable length field, lets call it AcNum, I want to ONLY keep the first 4 characters of the string and replace the rest with '*'</P><P>So...</P><P>abcd789 would become abcd*** and</P><P>asdfghjk will become asdf****</P><P>Thank you</P> Sat, 16 Nov 2024 19:38:10 GMT https://community.qlik.com/t5/QlikView/Replace-values-in-a-variable-length-field/m-p/1648845#M730664 QFanatic 2024-11-16T19:38:10Z https://community.qlik.com/t5/QlikView/Replace-values-in-a-variable-length-field/m-p/1648875#M730665 <P>What about formula:</P><P><EM>=Left('abcdefgh', 4) &amp; Repeat('*', Len('abcdefgh') - 4)</EM></P><P>&nbsp;</P><P>The result is as following:</P><P><EM><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_1.png" style="width: 149px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/24018i94DBF0E1B051779A/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot_1.png" alt="Screenshot_1.png" /></span></EM></P> Wed, 20 Nov 2019 07:35:27 GMT https://community.qlik.com/t5/QlikView/Replace-values-in-a-variable-length-field/m-p/1648875#M730665 MindaugasBacius 2019-11-20T07:35:27Z