<div>
Something like this - pulling from right to left...<br />
<br />

<pre><code id="code-20-42593922-1">myData = 90807

rightMost = right(myData,2)
middle=RIGHT(LEFT(G11,LEN(G11)-2),2)
leftOver = =RIGHT(LEFT(G11,LEN(G11)-4),2)

newData = leftOver &amp; &quot;:&quot; &amp; middle &amp; &quot;:&quot; &amp; rightMost</code></pre>
</div>


Something like this - pulling from right to left...



myData = 90807

rightMost = right(myData,2)
middle=RIGHT(LEFT(G11,LEN(G11)-2),2)
leftOver = =RIGHT(LEFT(G11,LEN(G11)-4),2)

newData = leftOver & ":" & middle & ":" & rightMost

Capture.PNG

<div>
Thank you. I just pulled the LINQ code and it worked just as I need.<br />
<br />
Andy
</div>


Thank you. I just pulled the LINQ code and it worked just as I need.

Andy

<div>
<div class="content wysiwyg-content">
Hi Experts, <br />
<br />
Party politics and partly the other dev doesn't want to change the data format he is sending I've been left with this problem.<br />
<br />
I have an integer made up of 3 parts for example: 131110 I need to display this as 13:11:10.<br />
<br />
How do I efficiently split this using asp.net VB.<br />
<br />
This is further complicated by having to drop any leading zeros so:<br />
<br />
90807 needs to show as 9:8:7 (the data width is 6, so assuming the left most digit to be 09)<br />
081207 shows as 8:12:7<br />
etc<br />
<br />
Can anyone point me in the right direction please.<br />
<br />
Andy
</div>
</div>


Hi Experts, 

Party politics and partly the other dev doesn't want to change the data format he is sending I've been left with this problem.

I have an integer made up of 3 parts for example: 131110 I need to display this as 13:11:10.

How do I efficiently split this using asp.net VB.

This is further complicated by having to drop any leading zeros so:

90807 needs to show as 9:8:7 (the data width is 6, so assuming the left most digit to be 09)
081207 shows as 8:12:7
etc

Can anyone point me in the right direction please.

Andy

Split an integer to create ':' separated string

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.