Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need help in calculating count of valid data, on particular column;
for e.g.
'Cust_name' is column name having below data:
Antony
paul
Ashish1234
#tony
Jas@n!
423165
Vish@l
I should get count as 3 - as valid data for us is - only char+ char-num (i.e.Antony, paul, Ashish1234 is valid data).
Data where only numbers, special char are present is not valid.
I tried doing same with purgechar/ keepchar but facing problem identifying data like 'Ashish1234' where char+numbers are present.
appreciate your help !
Thanks and Regards,
Ashish
May be this?
LOAD * INLINE [
Name
Antony
paul
Ashish1234
#tony
Jas@n!
423165
Vish@l
];
Using text object:
= Count(IF(NOT WildMatch(Name, '*#*','*@*','*!*') AND NOT ISNUM(Name), Name))