How to remove special character

[Anonymous]

Hi

My source like this

Sno,  Snd

1,["XXX","RRR \u0026 OOO"]

2,

3

4,xxx

EXPACTED O/P

we wanrt filter level give snd showing below

Snd listobject level blank is sowhing "NA" chart level it showing blank

Snd

xxx

RRR&OOO

NA

expacted o/p in chart level

Sno,Snd

1,XXX,RRR&OOO

2

3

4,XXX

How it will get

[jonathandienst]

For a small number of these enitity encoded characters, you could use a mapping table and the MapSubstring command to apply the changes. Like this:

MAP_ENCODINGS:

LOAD * Inline

[

  Code, Char

  \u0026, &

];

// add more encodings per your requirements

Result:

LOAD Sno,

  Snd as Snd_ORIG,

  MapSubstring('MAP_ENCODINGS', Snd) as Snd

FROM ....

[Anil_Babu_Samineni]

Probably define at least 5 Rows which is not relevant to each

[Anonymous]

Hi Anil,

My souece like below...

sno,snd,name

1,["A","b","c\u0026 n"],raju

2,["d","e","f"],ravi

3,,ramu

4,,Nani

I am expacted in list box level

snd

a

b

c&n

d

e

f

Na

and chart level

when ever clik on "NA" in lis box

sno,snd,name

1,,raju,

2,,ravi

3,,Ramu

4,,Nani

and when ever select snd listbox inside "A" o/p like below..

sno,snd,name,

1,a,b,c&d.raju

thanks

nani

[Chanty4u]

in this output  is so many rows?

sno,snd,name

1,["A","b","c\u0026 n"],raju

2,["d","e","f"],ravi

3,,ramu

4,,Nani

I am expacted in list box level

snd

a

b

c&n

d

e

f

Na

[Anonymous]

yes