Reading a Delimited File Using ASP.NET and VB.NET
page 1 of 4
Published: 01 Dec 2003
Unedited - Community Contributed
Abstract
This article will let you know how to read a delimited text file using asp.net or vb.net, which will explain about various aspects of a delimited file, code explanation and source code.
by G Ajaykumar
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 41123/ 38

Introduction

We must be aware of importing data into a database, data which is used for importing are normally in the form of text file, some times these files are called a comma separated value file, which will normally have an extension .csv ,

In either of the files whether a text file or a .csv file all the values are delimited using a word or a letter or a number, this particular text which is used for separating the values is called a delimiter. This delimiter may be a word, a letter, a comma, a tab, or a space. Based on text which is used for separating the value, their respective file name goes on accordingly, for example if the values are delimited by comma (,) and the file may be called as comma delimited file, if the values are delimited using a delimiter hash (“#”) then that file may be referred to as a hash delimited file.

            Let us have a look of an example of what these delimited files look like.

View Entire Article

User Comments

Title: Life Saver and excellent article   
Name: Muzaffar Sadiq
Date: 2007-12-14 7:34:01 AM
Comment:
I really appreciate if you could tell me that after reading data from a delimited file, how I can put data (value) in SharePoint list?

Thank you
Title: Excellent article!!   
Name: Cilina
Date: 2007-12-10 8:52:57 PM
Comment:
This is an excellent article. It works out so pretty :))))))))
Title: Localisation Manager   
Name: JaimeHy
Date: 2007-07-20 3:48:36 PM
Comment:
Nice article. Detailed enough explanation.

Very complete.

Thanks!
Title: Check out this library   
Name: Netra
Date: 2007-02-25 3:30:50 PM
Comment:
forgot to post URL!

http://vishalseth.com/blog/vishaltextfileutils/

there it is.

this library does everything with delimited files. it can convert to and from any format, open, write, read, reorder columns. Very usefull.
Title: Check out this library   
Name: Netra
Date: 2007-02-25 3:29:37 PM
Comment:
this library does everything with delimited files. it can convert to and from any format, open, write, read, reorder columns. Very usefull.
Title: very good   
Name: a visitor
Date: 2006-12-20 10:08:11 AM
Comment:
a same copy can be found out also at the link below ...
http://www.devarticles.com/c/a/ASP.NET/Reading-a-Delimited-File-Using-ASP.Net-and-VB.Net/
Title: how to read a delimited text file using asp.net   
Name: Dung vu
Date: 2006-11-28 12:09:38 PM
Comment:
It is very interesting article. How can I insert this array into SQL database? Please Help. Thank you.

Dung Vu
vincenthuyvu@sbcglobal.net

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-04-19 3:01:59 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search