How to remove null and special character in list box

[Anonymous]

Hi

My source like below

Client name

(Null data)

[Raju,"ramu"]

[Ravi,/u206]

Excapted o/p is

Client name

NA

Raju

Ramu

Ravi

[jonathandienst]

You can use the expression in the list box:

=KeepChar([Client name], 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')

[surendraj]

MAY BE THIS

TEXT(IF(SUBSTRINGCOUNT(Client name,',')=1,SUBFIELD(Client name,','),'NA'))

[jonathandienst]

Although a better option would be to derive a clean name field in the load:

LOAD ....

     [Client name] as [Client name RAW],

     KeepChar([Client name], 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz') as [Client name],

     ....

[tresesco]

PFA