Reading a Delimited File Using ASP.NET and VB.NET
page 2 of 4
by G Ajaykumar
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 40549/ 31

Examples of Delimited Files

Example: Comma-delimited file

Value1, Value2, Value3, Value4, Value5

In the above example we can see a comma between the words Value1 Value2 until Value 5.

Example: TAB delimited file

Value1            Value2            Value3            Value4            Value5

In the above example we are able to see space between all the values.

We have seen how a delimited text file looks like; now let us have a look of other usage of delimited file.

 

  1. Data import into Database
  2. Used as a Database

Let us go in detail how these delimited files are used in both of the cases.

  1. Data import into Database

In a DBMS, RDBMS we create databases and tables, in a huge database with millions of records, in order to transfer data from one database or transport a database from one location to another, data is normally exported into a text file, when we try to export data to a text file, system will ask for a delimiter to be used for, when we specify the delimiter, the data’s stored in the fields will get appended with the delimiter, while importing the data back to the database, system will ask for the delimiter which is used, based on the delimiter, data gets imported into the database.

  1. Used as a database

In some areas where there is no support of database, delimited text files are used as a replacement for database with limited functionality, data’s are directly read from the delimited text file into arrays and manipulated.

Usually these types of delimited text files are used in the web applications, where hiring a database support with hosting is a costly affair, in order to get an act support like a database these delimited text files are used.


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-05-24 11:58:09 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search