Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello..
i wanna ask, how to count certain character in a word?
example, i have few records in a column
columnA
-------------
mine.A
mine.A.B
bye.A
bye.A.B.C
thanks.A
thanks.A.A.C.D
and i want to know hos much dot (.) character show in every records
how can i do that in qlikview?
many thx...
@richardo:
meaning your not using the dots as a delimiter??
try using this one(expression): =Len(Word)-Len(Replace(Word,'.',''))
You want to count the dots??
@mOngkz
yes i do
but i dont know the function to do it
can anyone give me a hand please..
many thx...
you can also use this in your expression: TextCount(SubField(Word,'.'))-1
to count the dots/delimiter.
@mongkz
it almost rite, but doesnt rite
some times it tells two dots when the word have more then two dots
i really stuck n need a help really
😞
many many thx...
@richardo:
meaning your not using the dots as a delimiter??
try using this one(expression): =Len(Word)-Len(Replace(Word,'.',''))
@mongkz
it's perfect
thx a lot mongkz
really many thx to u
I'am glad that I helped you.. I am new to qlikview too so I use this forum as my training ground.
I suspect this would work more efficiently:
substringcount(ColumnA,'.')