Find the same text multiple times in a string seperated by commas
 

I can do a find on my text string and it returns the number of the first
character of the text, my problem is when it shows up multiple times in the
same string how do I extract the number for each repetition.
Example:
0573300,0573300,0251024,0257013,0257025,0257070,02 51024,0642510,0280347,3526440,0251024,0280346,0280 501,0512520,MCP
You can wee that 0251024 shows up 3 different times so I get 17 when I do a
find. The question is, how do I get the other 2 to show up?
--
clcnewtoaccess

Find the same text multiple times in a string seperated by commas
 

=FIND(SearchString,MasterString,StartingPosition)
The third parameter is the starting position.
You give 1 to return the 1st instance ie 17
You give 18 to return the 2nd instance

--
If this post helps click Yes
---------------
Jacob Skaria


"clcnewtoaccess" wrote:

I can do a find on my text string and it returns the number of the first
character of the text, my problem is when it shows up multiple times in the
same string how do I extract the number for each repetition.
Example:
0573300,0573300,0251024,0257013,0257025,0257070,02 51024,0642510,0280347,3526440,0251024,0280346,0280 501,0512520,MCP
You can wee that 0251024 shows up 3 different times so I get 17 when I do a
find. The question is, how do I get the other 2 to show up?
--
clcnewtoaccess