[ASK] how to count certain character?

[#1]

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...

[#2]

You want to count the dots??

[#3]

@mOngkz

yes i do

but i dont know the function to do it

can anyone give me a hand please..

many thx...

[#4]

use subfield function:

Directory;

LOAD Word,SubField(Word,'.') as sub

FROM

[source.xlsx]

(ooxml, embedded labels, table is Sheet2);

in the expression tab:

Count(sub) - 1..because eventually the number of words is greater than the number of dots..if the dots are used as delimiter

[#5]

you can also use this in your expression: TextCount(SubField(Word,'.'))-1

to count the dots/delimiter.

[#6]

@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...

[#7 · Accepted solution]

@richardo:

meaning your not using the dots as a delimiter??

try using this one(expression): =Len(Word)-Len(Replace(Word,'.',''))

[#8]

@mongkz

it's perfect

thx a lot mongkz

really many thx to u

[#9]

I'am glad that I helped you.. I am new to qlikview too so I use this forum as my training ground.

[johnw]

I suspect this would work more efficiently:

substringcount(ColumnA,'.')