<div>
This works great, however, I also need the code to detect this type of string:<br />
<br />
102-0618-001 R12-18,R126-131,R140<br />
<br />
and have it display in the same format as the other strings.<br />
<br />
<br />

</div>


This works great, however, I also need the code to detect this type of string:

102-0618-001 R12-18,R126-131,R140

and have it display in the same format as the other strings.




<div>
you can add one of two things to the code:<br />
1) some parsing that looks for comma-delimited ranges, then passes each separately to<br />
&nbsp; &nbsp; &nbsp; &nbsp;the ExpandNumbers routine, <br />
or<br />
2) code in ExpandNumbers itself, which looks for dash *or* comma, treating each separately.<br />
&nbsp; &nbsp; &nbsp; &nbsp;the problem here is, how do you know when a dash is in the prefix or in a range?<br />
&nbsp; &nbsp; &nbsp; &nbsp;you'd be stuck assuming that the alpha that precedes will *always* be there...<br />
<br />
Larry<br />

</div>


you can add one of two things to the code:
1) some parsing that looks for comma-delimited ranges, then passes each separately to
       the ExpandNumbers routine,
or
2) code in ExpandNumbers itself, which looks for dash *or* comma, treating each separately.
       the problem here is, how do you know when a dash is in the prefix or in a range?
       you'd be stuck assuming that the alpha that precedes will *always* be there...

Larry


<div>
Sorry about the delay in responding. &nbsp;The code and advice you gave worked great. Thank you.<br />
<br />
Rob.<br />

</div>


Sorry about the delay in responding.  The code and advice you gave worked great. Thank you.

Rob.


<div>
<div class="content wysiwyg-content">
I need to format a string and display the results in a list box. &nbsp;A couple of string examples would be:<br />
<br />
34030089 U110-115<br />
100-0714-001 R113-114<br />
<br />
I need it to be displayed in a list box, in this format:<br />
<br />
34030089 U110<br />
34030089 U111<br />
34030089 U112<br />
34030089 U113<br />
34030089 U114<br />
34030089 U115<br />
100-0714-001 R113<br />
100-0714-001 R114<br />
<br />
I have multiple strings to work with and I can't seem to be able to get the desired information accurately.
</div>
</div>


I need to format a string and display the results in a list box.  A couple of string examples would be:

34030089 U110-115
100-0714-001 R113-114

I need it to be displayed in a list box, in this format:

34030089 U110
34030089 U111
34030089 U112
34030089 U113
34030089 U114
34030089 U115
100-0714-001 R113
100-0714-001 R114

I have multiple strings to work with and I can't seem to be able to get the desired information accurately.

Displaying a string in a different format

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.