Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

counting specific characters in a string 3

Status
Not open for further replies.

JeroenBoon

Technical User
Aug 15, 2002
106
NL
Hello,

(This must be a simple one, but I can't find the answer...)
whe I would like to count a specific character in a string, is there a formula for that? For instance: I want to count the character / in the description of articles.

Thanks, Jeroen.
 
don't know if there is a simpler way than this but here's my idea

len({fieldname}) - len(replace({fieldname},'char to find',''))

replacing {fieldname} with the field to check and char to find with the character to look for.
 
@ huggyd:

thanks for your answer. I came up with your solution myself, but I thought that for something as simple as this there would be a formula like count({string},"/") that I just can't find...

Jeroen.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top