Search:

Doing the first part is easy andi already have a function for that,its like a counter that stores the column number which has date as its name,But being a text file i dont know how i can change the...

Hi Datamiser,

Actually it finally works,i dug thru some examples of split for flatfile reads and here is the final code,thanks a lot for helping me anyways



Dim SourceFileName As...

Yea i did change the variable to to st and tried to step thru the code,it just doesnt come into this loop below

If sp.Length > 4 Then

strdt = sp(3).ToString()

...

I did find examples like the above,here is the problem with my code..its not going into the loop to replace the date column into current date..i think the split function is not been used in the right...

There are no examples on the web so far and yes i tried readalllines,split,but i am not able to do it,i need some code,can you help?

I have 100sof flat files that have lots of data,every line of the file is having a space in between each column value,the first line is a header for all the columns,i want to modify all the date...