How to remove the special charters in script level - Qlik Community

Anonymous · ‎2018-01-17

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"]

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

zhadrakas · ‎2018-01-17

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, '[]""\/')

Anonymous · ‎2018-01-17

Hi ..

Not for remove Replace the Character....

o/p like above