Question Got a problem with opening CSV files.

[iDASTANx]

Hey guys

Pretty new at Visual Basic (just getting that out there before I continue).

So, for my computing project I have to import csv files (got that bit working, got it opening up and displaying in a text box) and search through it to find criteria that I want.

Anyways, I am having trouble splitting/parsing the csv file so that it will display with no comma's (in a kind of tabbed form) e.g. at the moment it displays as

"A,B,C,D,E,F
1,2,3,4,5,6
H,W,J,D,U,R"

but I want it to display it like

"A B C D E F
1 2 3 4 5 6
H W J D U R"

If you get what I mean? any help would be much appreciated

Thanks!

Jamie.

 

[jmcilhinney]

One option would be to use String.Replace to replace all commas with ControlChars.Tab.

 

[iDASTANx]

Hey, thanks for the reply

But how would I go about this ? (code wise)

 

[jmcilhinney]

I like to see people try for themselves first. You know what method to use. Look it up in the documentation and search for examples online. If you have trouble, post back and show us what you've done and we can help but do make an effort first. It really is the best way to learn. It's harder but more rewarding. I'm interested in your learning as much as possible moreso than just solving this one problem.

 

[iDASTANx]

Ah ok, never tried that way before, shall give it a shot! Shall report back here if I have any problems or get it working, but thanks, again!