
08-19-2003, 12:12 AM
|
|
Junior Contributor
|
|
Join Date: Jun 2003
Location: Australia
Posts: 241
|
|
Once you have the position of the starting and ending ##'s (pos1 and pos2) you could use something like:
Code:
extractedstring = Mid(str1, pos1 + 2, pos2 - pos1 - 2)
To extract the information between the first ## and the second ##.
Also, you might need to change:
Code:
pos2 = Instr(pos1,str1,"##")
'to
pos2 = InStr(pos1 + 1, str1, "##")
|
|