HI all,
I've a specific requirement where in there will be 2 text files which will have information like normal text plus date and time stamp of communication. Basically, the VB code should read each line of text file and copy date and time to one column in excel and other text contents to second column. all text contents are available only after date and time format like [12/30/2015 10:01 PM] Srinivasan Varadaraj: Dear All, We have .....................blablabla....
So what I want is copy 12/30/2015 10:01 PM in Column A and everything after ":" should be in Column B..
Like this, Code should read through end of text file and where ever the time stamp is written, copy to Excel Column A and remaining text after ":" to Column B.
Let me know if I've made my self clear to explain my requirement. I need to submit a project by EOD tomorrow. Any quick help is highly appreciated.
Please
I've a specific requirement where in there will be 2 text files which will have information like normal text plus date and time stamp of communication. Basically, the VB code should read each line of text file and copy date and time to one column in excel and other text contents to second column. all text contents are available only after date and time format like [12/30/2015 10:01 PM] Srinivasan Varadaraj: Dear All, We have .....................blablabla....
So what I want is copy 12/30/2015 10:01 PM in Column A and everything after ":" should be in Column B..
Like this, Code should read through end of text file and where ever the time stamp is written, copy to Excel Column A and remaining text after ":" to Column B.
Let me know if I've made my self clear to explain my requirement. I need to submit a project by EOD tomorrow. Any quick help is highly appreciated.
Please
