User: editor -- 2011-12-30 << 899 901 >> |
Hits: 4489 |
Type: Text file parser |
Search all Text file parser examples |
Description: |
How to extract lines in specified month in multiple excel(csv) files? I have multiple excel(csv) files, there is date in column A, how to extract all the rows with date such as 2011-12-xx? |
Input Sample: |
Multiple CSV files like: 2011-11-23,182,224,174,48,9,58 2011-11-24,171,268,229,58,12,38 2011-12-08,200,276,216,34,13,57 2011-12-16,134,174,138,32,8,37 2011-12-17,124,468,428,19,5,40 |
Output Sample: |
Extract all 2011-12-xx rows and make a single CSV files: 2011-12-08,200,276,216,34,13,57 2011-12-16,134,174,138,32,8,37 2011-12-17,124,468,428,19,5,40 |
Answer: |
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
1. Open "Tools->Batch Runner" menu 2. Drag and drop multiple csv files from Windows file browser to "Batch Runner" window. 3. Click "Fast Replace" button to open "Fast Replace" dialog 4. Click "Add" to add new rules * set "search" to * set "replace" to * click "ok" 5. check option of "Reg exp" and "Extract", uncheck option of "cross line" 6. click "Start" and select "output to single file", and enter an output file such as output.csv, done. |
Screenshot 1: Fast_Replace_Window |