Count of fields consisting special character from particular column

[#1]

Hi All,

I am new to Qlikview,

I need help, I am trying to have count of records from particular column in database, where there is junk data with special  characters.

for e.g.:

Name

Robert%#

Ashish

Alax12

Jon

I should get count as 2 , as two fields are there with special characters.

Thank you

[tamilarasu · Accepted solution]

Hi Ashish,

=Count({<Name={"=Len(PurgeChar(Upper(Name),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))>0"}>}Name)

Or

=Count(If(Len(PurgeChar(Upper(Name),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))>0,1))

[#3]

Thanks Nagraj for your reply...

It worked for me .. However could you please help me in below case ...

Name

123Art Johnson,III

Dustin Graves

!!!$%VALMONT INDUSTRIES, INC.

PACCAR####

CTC-Suite Renovation Program-1x4

&&&*****Unknown****

****CRM****####

12345 JCI project. 57 Luxor 300 156 Luxor 600

AAP !!!####%%%%&&&

****AAMCOR ***

123134343424542sasdsfpoi*******

Ashish

Yogita

##### Poonam *******####

Sandhya

Madhu******!!!!!!$$$$

Ansuman

***#####&&&***##Anthony****

Soumya

Rohin())()()-----

Amit1234

I would like to have count of field where only number (not char followed by number) , fields with  special char , blank fields and fields with white spaces ?

Could you please help.