Reading a Delimited File Using ASP.Net and VB.Net - Usage (Page 2 of 6 )
We have seen what a delimited text file looks like; now let us have a look at other types of usage of a delimited file:
Data import into a database
Used as a database
Let us go into detail on how these delimited files are used in both of the cases above:
Data Import into a 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 to another or to 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, the system will ask for a delimiter to be used. When we specify the delimiter, the data stored in the fields will be appended with the delimiter. When importing the data back to the database, the system will ask for the delimiter, and based on the specified delimiter, the data will be imported back into the database.
Used as a Database
In certain environments, where there is no database support, delimited text files are used as a replacement. With limited functionality, data is read directly from the delimited text file into arrays and then manipulated. Usually these types of delimited text files are used in web applications, where hiring database support along with hosting can be a costly affair. In order to emulate a database, these delimited text files are used.
We have seen what a delimited text file is, as well as the important usage and applications these delimited text files can be used for.
We will now move on to see how to read these delimited text files using ASP.Net and VB.Net.
Delimiters are sometimes referred to as splitters.