Forum Discussion

ScottRobertson's avatar
ScottRobertson
Qrew Trainee
5 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
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
5 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
------------------------------