Forum Discussion

LanePemberton's avatar
LanePemberton
Qrew Cadet
7 years ago

Count characters in a string, find string location in a string, etc?

Is there still no way to count occurrences of a string within a string? Or to find the index of the first occurrence of a string within a string? The reason I ask is because this seems like a simple o...
App builders
Forms
Formulas and functions
DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago
You can always pass the string via URL parameter to a custom code page and do the string coding there via JavaScript or whatever. You can then display the value on the code page if you are just needing to know the number. There are additional options for putting that value back into a record field but it is more lengthy. 
LanePemberton's avatar
LanePemberton
Qrew Cadet
7 years ago
Good suggestion David. I've used the IOL technique before but mostly as an action that runs off of a button click. I'm not sure the best way to run JavaScript from a formula and have it auto calculate (I guess that will be my next question). It would be nice to be able to use 'search', 'indexOf', 'match', etc.