Hi
I need to process a CSV file but the input csv file is having some unwanted data in the beginning like the name of the file,purpose of the file ,date when the file was generated.I have to create a SChema.INI file on the fly.But the presence of these additional lines in the beginning is causing many problems.I need to delete these first 5 rows from the file dynamically and then start the creation of ini file.But i am stuck!:(Please provide me with a solution.

Him Nish

I imagine you have some loop that goes thru each line. Can't you just add some logic to skip the first X lines?

Can you post the relevant code so we may help you better?

-Peter

i dont have any code for implementing this as yet..But i know that this is possible using File System Objects or File stream objects.
I tried this using file stream:by stream reader i read the file and using a loop and stream writer wrote the contents into another csv but this writing into another file is sometimes changing the datatype of some of the column as a result of which i m nt getting the expected results.so do u know how to achieve this using FSO?

Him Nish

How can something change a datatype of data in a CSV file? Inherently, all data in a CSV files is textual.

Well, which is it? Either you have tried it or you haven't. What code have you tried so far? Have you looked at the classes in System.IO? The System.IO.File class would be a good place to start.

-Peter

Have you tried this:

Dim reader as new system.io.streamreader("yourCSVFile.CSV"), lineIn as string

For x as integer = 0 to 4
Reader.readLine
Next

While reader.peak <> -1
LineIn = reader.readline
'Do your processing on LineIn. If you call readline again, it'll go to the next line
Wend

reader.close


?? Though a cleaner way would be to write logic and deduce which lines are the bad lines, incase its more than 5, less, etc. Code like this can have undesired effects later if you change the file.

--Ryan Campbell
ryan@extremewebguy.com