Click here to Skip to main content
15,893,588 members
Please Sign up or sign in to vote.
4.00/5 (2 votes)
See more:
Hi,

I'm writing a program for my work that automates certain database files.
Most of the files are in csv or fixed-length ascii format (txt).

Now excel has a beautiful import wizard where you can put column seperators
with your mouse etc. Access too..

Are there ANY controls who mimic this kind of control?

That would save me a lot of time programming it myself..

Any tips on where to download or how to approach writing a control/dialog
with these functionalities are welcome.

Gr. Daniel


Added:
I'm not looking for a way to import csv (blabla.Split())
or a way to select text from a fixed ascii (blabla.Substring(0, 10))
Just a way to build an importwizard that does this, or a place where
this control is available.
Posted
Updated 28-Feb-11 5:00am
v2

1 solution

I don't know about controls that you described but you can use the following method for each line in your CSV file:
String.Split[^]

This should be easy...
 
Share this answer
 
Comments
Sergey Alexandrovich Kryukov 28-Feb-11 10:58am    
Nice and simple, my 5.
--SA

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900