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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Gowtham174
Creator
Creator

Need to remove (****) from data set

Hi All,

Can you please help me to remove the bracket values present in the data set where inside the bracket() remove all the information along with bracket and replace with . dot.

Example:

Data field

Field1.

My name is (0000) Gowtham

Output should be

Field1.

My name is . Gowtham

Thanks,

Gowtham

11 Replies
Quy_Nguyen
Specialist
Specialist

I dont understand what you  are trying to show.

Why you have to put these brackets in the PurgeChar function? We just want to remove digit.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunction...

nsetty
Partner - Creator II
Partner - Creator II

Got, please ignore my previous post