Forum Discussion

ScottRobertson's avatar
ScottRobertson
Qrew Trainee
6 years ago

Count the number of specific characters in text field

Hello, Is it possible to count the number of specific characters within a text field? What I'm looking to do is count the number of delimiters (";") within a text field to determine the number of e...
Data import and export
Formulas and functions
ScottRobertson's avatar
ScottRobertson
Qrew Trainee
6 years ago
Appreciate the input!

​The other issue I failed to mention is that the length of that field can range from 1 delimiter to 50,000+... would I need to complete 50,000 "trims" with this solution?
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
…
Trim(Part($value,50000,";"))<>"",


------------------------------
Scott Robertson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Yes, 50,000, which I'm sure would hit either Quick Base limits or limits of your patience.  This would require a JavaScript solution.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • ScottRobertson's avatar
    ScottRobertson
    Qrew Trainee
    6 years ago

    Thanks Mark, that's what I was afraid of.

     

    This information is coming in through an API so I'm going to explore obtaining the counts before posting to QuickBase.

     

     

    Thanks again,
    Scott


    Confidentiality Notice:
    This e-mail, including any attachments is the property of Trinity Health and is intended for the sole use of the intended recipient(s). It may contain information that is privileged and confidential.  Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please delete this message, and reply to the sender regarding the error in a separate email.


    ------Original Message------

    Yes, 50,000, which I'm sure would hit either Quick Base limits or limits of your patience.  This would require a JavaScript solution.

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