If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#4
|
|||
|
|||
Count for multiple occurrence of an expression in a string
You are awesome. This answers my question
Thanks a lot ! "Larry Daugherty" wrote: What comes redily to mind is a function that accepts two arguments: the string to analyze and the comparison character. Look in Help for Mid. The function would return an number of times the comparison character was found in the string as an integer. HTH -- -Larry- -- "chinky" wrote in message ... I want to count number of '.' (dots) in an expression e,g. asd.rty.de.com (answer = 3 dots at positions 4,8,11 respectively) . Instr functions gives only the first occurrence. Any help is appreciated Thanks Anupam |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count Occurances of String in a Column? | Bill | General Discussion | 4 | February 23rd, 2006 12:30 AM |
Print Search Listbox Results in Report Filter Preview ... HELP!!! | [email protected] | Setting Up & Running Reports | 0 | January 27th, 2006 07:34 PM |
Requested string function | Tom Ellison | Running & Setting Up Queries | 3 | December 15th, 2005 06:58 PM |
COUNT: Counting the number of times "X" comes up after the occurrence of "Y" | DrSues02 | General Discussion | 5 | August 3rd, 2004 06:35 AM |
Tough One, trying to count occurences of string based on string in separate column | RagDyer | Worksheet Functions | 2 | February 28th, 2004 02:10 AM |