I have a column containing values like below, from which i need to comma separate the values and take the distinct count
Note: If there is any null or empty string that should not be considered for count
col1
===
ab,bc,cd,cd,cd
ab,ab
ab,' ',bc,bc,' '
output:
=========
col1
====
3
2
2