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: 
Anonymous
Not applicable

How to remove null and special character in list box

Hi

My source like below

Client name

(Null data)

[Raju,"ramu"]

[Ravi,/u206]

Excapted o/p is

Client name

NA

Raju

Ramu

Ravi

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

You can use the expression in the list box:

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
surendraj
Specialist
Specialist

MAY BE THIS

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

     ....

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
tresesco
MVP
MVP

PFA

Capture.JPG

Capture2.JPG