Discussions

Expand all | Collapse all

how to count the number of specific characters

Jump to Best Answer
  • 1.  how to count the number of specific characters

    Posted 11-12-2019 07:49
    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;"

    thanks
    Pushpakumar

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


  • 2.  RE: how to count the number of specific characters
    Best Answer

    Posted 11-12-2019 07:51
    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
    ------------------------------



  • 3.  RE: how to count the number of specific characters

    Posted 11-12-2019 08:01
    Hi mark,

    Thanks a lot !

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



  • 4.  RE: how to count the number of specific characters

    Posted 28 days 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
    ------------------------------



  • 5.  RE: how to count the number of specific characters

    Posted 28 days ago
    I like that solution.

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