In String (Instr "Text,Of,a string")..2' occurence of ","
Posted: 21 Jul 2011
Hello
Maybe a simple question, but i did not resolved it
I got a string "Text,Of,a string")
I want to decode what is the characters number for each comma " , "
Instr("Text,Of,a string"), "," ) will give me the occurrence of the first ","
I need to get it for all " , " of the string. In Excel it is fairly easy since you have to enter the starting position in the string.
Martin
Maybe a simple question, but i did not resolved it
I got a string "Text,Of,a string")
I want to decode what is the characters number for each comma " , "
Instr("Text,Of,a string"), "," ) will give me the occurrence of the first ","
I need to get it for all " , " of the string. In Excel it is fairly easy since you have to enter the starting position in the string.
Martin