Search : in
By :

Extract data using vbscript

woodysgreen, on Oct 28, 2009 9:41:40 pm GMT 
 Report this message to moderators

Hello,
I'm looking for a vbscript which will go through many csv files and extract data between certain rows. The rows to be extracted will depend on a month.
All of the data in each of th csv files will start at row 3 and end with a blank row. So, if the month has 28 days then the data to be extracted will be between rows 3 and 30. If the month has 31 days then the rows to be extracted will be between row 3 and 33. All data after the blank row is not needed. The script should be able to go trough many csv files and output the result to one csv file for parsing.

Thanks in anticipation

woodysgreen

Configuration: Windows 7 Internet Explorer 8.0

Best answers for « Extract data using vbscript » in :
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
XTM file extension ShowExtension .XTM How to use XtremSplit? An XTM file extension is a data created by the XtremSplit program. This software is used to split large files into smaller ones and then rebuild them. Download XtremSplit from...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Download MyDataChameleon Show
Download TxtConv ShowTxtConv is a file conversion utility. As its name suggests, it allows to convert a text format to another. Its main feature is to extract data from a text file in columns. It can rewrite the whole columns or only a part of them by changing their...
Download Some PDF Image Extract ShowDocuments PDF can include of the text, of graphs, pictures but also pictures. Given that it is not possible to change contents, the same is true of for the extraction of a picture of the contents of the document. Some Colorful PDF Extract is a tool...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Data transmission - Introduction ShowData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to...
Ask your question Reply
They need your help