Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extremely New

Status
Not open for further replies.

V00D00

Technical User
Jul 11, 2005
78
US
I am extremely new to Visual Basic and .NET. I come from using Perl as a sysadmin, so most of my scripts are for list iteration.

My first attempt at a VB application will be to take a comma delimited file and reformat it, both in field order and for content. Can someone point me in the right direction with some tutorials with File I/O and list iteration with VB?

Thank you.
 
I would probably use EXCEL classes for CSV files to open them for processing. Then inside EXCEL, recorded macros to reorder columns & for reformatting and simply with appropriate editing transferred VBA code into .NET code, then saved the file in CSV format again (by cheating with EXCEL macro recorder again).

Just make sure you will not loose the formatting you need when saving in CSV file.


vladk


 
Does this scenario work with no versions of Office installed?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top