Click here to Skip to main content
14,238,693 members
Rate this:
Please Sign up or sign in to vote.
So I'm still getting use to VB.NET as I haven't had much time to play with it, and haven't done alot of coding since back in the vb6 days. Anyways, I'm working on a small personal project for me and my business partner to handle certain customer information.

Basically it just has a few text boxes and buttons to enter information, name, account status, contact info, ect. then loads the information into a list and saves it. There's a few different list boxes the information moves between, for instance, previous customer, current customer, outstanding balance, ect.

What I'm wanting to do to make our lives easier with this program and running into an issue figuring out HOW to do it is quite simple I think. I'm just too rusty to figure it out right away. When we import/export an account from or to a list (Outside the program) it's formatted like so:

"Name - Residential/Business - Account Status"

What I'd like to add is a feature to format the list differently for different purposes. Sometimes we need the list formatted with a - between the 3 pieces of data exported/imported, sometimes we need a :. I know it HAS to be simple to make a function to load a list that's formatted like

"user:account:status" and convert it to "user - account - status"

Also would like to be able to change the order as well in the conversion if possible, instead of per say "user:account:status" to "account:status:user" ect.

Just can't for the life of me get my head back into coding quickly enough to figure something so simple out. Sorry for the book and thanks in advance for ALL help ANYONE might give me on this! If it's any constellation to the matter I'm using Visual Studio 2013 at the moment.

What I have tried:

I can export the data from 3 separate text boxes with the preferred symbol separating them, but can't for the life of me figure out how to import a file and put the proper data in the proper box or reformat the way it's separated
Updated 19-Nov-18 22:22pm

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

You can use the String.Split Method (System) | Microsoft Docs[^] to separate the three parts. You may need an initial check to see which control characters are being used.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100