Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
d4rlie891
New Contributor III

change name to *

Hi,

I want to change the Name start from the 4th Char with *, is there any way to do that?

for Example :

Name :MICHAEL JACKSON

New Name : MIC************

Thanks

1 Solution

Accepted Solutions
hirishv7
Honored Contributor

Re: change name to *

Hi,

Check this

Left(Name,3) & Repeat('*',Len(Name)-3) as New

Name Replace -241638.PNG

-Hirish

2 Replies
hirishv7
Honored Contributor

Re: change name to *

Hi,

Check this

Left(Name,3) & Repeat('*',Len(Name)-3) as New

Name Replace -241638.PNG

-Hirish

d4rlie891
New Contributor III

Re: change name to *

Thank a lot for your Help

Community Browser