<div>
text = &quot;id1##id2##id3&quot;<br />
id1 = mid$(text,1,instr(text,&quot;#&quot;<wbr />) - 1)<br />
this will give you id1 for id2<br />
<br />
&quot;create a new value for text <br />
text = mid$(text,1,instr(text,&quot;#&quot;<wbr />) + 2)<br />
id2 = mid$(text,1,instr(text,&quot;#&quot;<wbr />) - 1)<br />
<br />

</div>


text = "id1##id2##id3"
id1 = mid$(text,1,instr(text,"#") - 1)
this will give you id1 for id2

"create a new value for text
text = mid$(text,1,instr(text,"#") + 2)
id2 = mid$(text,1,instr(text,"#") - 1)



<div>
Yep, sorry I forgot the -1<br />

</div>


<div>
<div class="content wysiwyg-content">
Ex.: I have this string &quot;id1##id2##id3&quot;. The ## are the delimiter in this string. I want to obtain the first part of this string, so all the caracter before the #. Is there any function in VB to do that?
</div>
</div>


Ex.: I have this string "id1##id2##id3". The ## are the delimiter in this string. I want to obtain the first part of this string, so all the caracter before the #. Is there any function in VB to do that?

Find a subset in a string

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.