Forum Discussion

Qrew Assistant Captain

6 years ago

how to count the number of specific characters

Hi All, Can you please help me with a function/code to count the number of specific characters in a string I would like to find the number of semicolon (;) in the string "hi;how;are;you;" th...

Formulas and functions

MarkShnier__You
6 years ago
This is a way to do it if there is some reasonable limit to the maximum number of semicolons

var text value = [my field with semicolons])

Count(
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
Trim(Part($value,4,";"))<>"",
Trim(Part($value,5,";"))<>"",
Trim(Part($value,6,";"))<>"",
Trim(Part($value,7,";"))<>"",
Trim(Part($value,8,";"))<>"",
Trim(Part($value,9,";"))<>"",
Trim(Part($value,10,";"))<>"",
Trim(Part($value,11,";"))<>"",
Trim(Part($value,12,";"))<>"",
Trim(Part($value,13,";"))<>"",
Trim(Part($value,14,";"))<>"",
Trim(Part($value,15,";"))<>"",
Trim(Part($value,16,";"))<>"",
Trim(Part($value,17,";"))<>"",
Trim(Part($value,18,";"))<>"",
Trim(Part($value,19,";"))<>"",
Trim(Part($value,20,";"))<>"",
Trim(Part($value,21,";"))<>"",
Trim(Part($value,22,";"))<>"",
Trim(Part($value,23,";"))<>"",
Trim(Part($value,24,";"))<>"",
Trim(Part($value,25,";"))<>"")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

MarkShnier__You

Qrew Legend

This is a way to do it if there is some reasonable limit to the maximum number of semicolons

var text value = [my field with semicolons])

Count(
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
Trim(Part($value,4,";"))<>"",
Trim(Part($value,5,";"))<>"",
Trim(Part($value,6,";"))<>"",
Trim(Part($value,7,";"))<>"",
Trim(Part($value,8,";"))<>"",
Trim(Part($value,9,";"))<>"",
Trim(Part($value,10,";"))<>"",
Trim(Part($value,11,";"))<>"",
Trim(Part($value,12,";"))<>"",
Trim(Part($value,13,";"))<>"",
Trim(Part($value,14,";"))<>"",
Trim(Part($value,15,";"))<>"",
Trim(Part($value,16,";"))<>"",
Trim(Part($value,17,";"))<>"",
Trim(Part($value,18,";"))<>"",
Trim(Part($value,19,";"))<>"",
Trim(Part($value,20,";"))<>"",
Trim(Part($value,21,";"))<>"",
Trim(Part($value,22,";"))<>"",
Trim(Part($value,23,";"))<>"",
Trim(Part($value,24,";"))<>"",
Trim(Part($value,25,";"))<>"")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

PushpakumarGna1

Qrew Assistant Captain

6 years ago

Hi Mark,

Just want to let you know that I found a easy way and it is length(string) - length(searchandreplace(string,";",""))

basically length("abcd") - length(searchandreplace("abcd","a",""))

Thanks
Pushpakumar

------------------------------
Pushpakumar Gnanadurai
------------------------------

MarkShnier__You
Qrew Legend
6 years ago
I like that solution.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
JosephSchultz
Qrew Member
4 years ago
This is just what I needed to find today. Nice solution!

------------------------------
Joseph Schultz
------------------------------
MichaelGibson
Qrew Member
3 years ago
Thank you for this. We were able to make a basic word counter for a text field by looking for the spaces.

------------------------------
Michael Gibson
------------------------------
JonFroderberg2
Qrew Trainee
6 months ago
Brilliant! This was the exact bit of code I needed for my application.
Thank you PushpakumarGna1