Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sekharapp
Contributor III
Contributor III
‎2022-06-11 03:06 PM

Interview question

I WANT TO REPLACE FIRST 4 LETTERS WITH *AND REMAINING LETTERS AS IT IS 

EX:****1234

WHAT IS THE SYNTAX FOR THIS?

Labels (5)
542 Views
0 Likes
1 Reply
HugoRomeira_PT
Creator
Creator
‎2022-06-12 01:32 AM

Hi,

You can apply the following:

'****' & mid([FielName], 4)

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
516 Views
0 Likes