[RESOLVED] Split the string by three and display on the listbox

[shyguyjeff]

Hello everyone, I have a problems regarding on how to display my data by 3 characters every listbox. This what really my problem is, I have data coming from my database and that specific field contains numbers but the problem is that is was merge and what i want is that i want to split that by 3 so that i can get the itemcode coming from other table that i need to display again on my grid or listbox. This is how it look like.


Ex. Data from my MS Access:

First Table
Pojectcode     ItemName
123456789      Potato Chips

Second Table:
ItemCode        BrandName
123                Mr.Chips
456                Lays
789                Cheetoos

by calling that project code how can i split that string into three? And how can i display that will look like the second table but display on listbox? Thanks in advance guys.