Re: Count the number of specific characters in text field
Scott,
If you have an external data source with the delimited text, you should transform the data before writing to Quick Base. What ever code you are using to extract from the other DB and load to Quick Base is undoubtedly more powerful than the formula fields in Quick Base. Quick Base is great but is deliberately kept simple for the Citizen Builder to be able to make business process applications for users.
Your case above is outside the box for Quick Base but not that difficult with a Loop in your external code. Then you can add a second field in Quick Base that is the Count of Delimiters as a Numeric field instead of a Formula Numeric.
I assume with the text field and numeric field you can then get on to the business case for why you wanted to import the data to begin with.
Good luck and happy building.
Don
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
If you have an external data source with the delimited text, you should transform the data before writing to Quick Base. What ever code you are using to extract from the other DB and load to Quick Base is undoubtedly more powerful than the formula fields in Quick Base. Quick Base is great but is deliberately kept simple for the Citizen Builder to be able to make business process applications for users.
Your case above is outside the box for Quick Base but not that difficult with a Loop in your external code. Then you can add a second field in Quick Base that is the Count of Delimiters as a Numeric field instead of a Formula Numeric.
I assume with the text field and numeric field you can then get on to the business case for why you wanted to import the data to begin with.
Good luck and happy building.
Don
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
