Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nagarjuna123
New Contributor II

How to remove the special charters in script level

  Hi  ..

my field like below..

where ever null data is there "NA" renaming data coming as usual.

Management

[]

["aaaaa -\u001a Chief Economist for Australia/NZ"]
["bbbbb -\u001a Chief Economist for Australia/NZ"]
["Hilton Worldwide Holdings","Park Hotels \u0026 Resorts Inc - US"]
["Hilton Worldwide Holdings","Park Hotels \u0026 Resorts Inc - US"]

excapted o/p is like below...

Management

NA

aaaaa& Chief Economist for AustraliaNZ

bbbbb &Chief Economist for AustraliaNZ

Hilton Worldwide Holdings

Park Hotels &Resorts Inc - US



2 Replies
zhadrakas
Valued Contributor II

Re: How to remove the special charters in script level

check the purgechar function.

you can try like this. add all symbols you want to remove.

You can also add chr(10) for a line break

PurgeChar(Field, '[]""\/')

nagarjuna123
New Contributor II

Re: How to remove the special charters in script level

Hi ..

Not for remove Replace the Character....

o/p like above