| User: editor -- 2009-05-25 << 334 336 >> |
| Hits: 530 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| I want to combine data rows in groups equal to weeks such that a month is made of four groups or weeks. The data is stock data and not all months are five day weeks because of holidays closing a market day. Hence, I would accept dividing each month into 4 groups. Can Replace Pioneer create four groups and total the columns? OPEN is the Average of all data rows HIGH is the Maximum value from the data rows LOW is the minimum value from the data rows VOLUME and CLOSE are the Average value |
| Input Sample: |
| 01/02/09 00:00 5.08 5.24 5.02 42700.00 5.17 01/05/09 00:00 5.21 5.26 4.94 58200.00 5.24 01/06/09 00:00 5.30 5.55 5.11 67400.00 5.45 01/07/09 ... 01/08/09 ... 01/09/09 ... 01/12/09 ... 01/13/09 ... 01/14/09 ... 01/15/09 ... 01/16/09 ... 01/20/09 ... 01/21/09 ... 01/22/09 ... 01/23/09 ... 01/26/09 ... 01/27/09 ... 01/28/09 ... 01/29/09 00:00 4.50 4.50 4.31 50900.00 4.34 01/30/09 00:00 4.33 4.71 4.20 74400.00 4.29 |
| Output Sample: |
| DATE OPEN HIGH LOW VOLUME CLOSE 01/02/09 12:00 5.08 5.24 5.02 42700 5.17 01/05/09 12:00 5.21 5.26 4.94 58200 5.24 01/06/09 12:00 5.3 5.55 5.11 67400 5.45 01/07/09 12:00 5.35 5.55 5.21 54600 5.45 01/08/09 12:00 5.32 5.51 5.32 29100 5.5 Jan 09 week 1 5.25 5.55 4.94 50400 5.36 01/09/09 12:00 5.46 5.5 5.31 24900 5.37 01/12/09 12:00 5.21 5.31 5 29500 5.06 01/13/09 12:00 5.05 5.21 4.98 27000 5 01/14/09 12:00 5.04 5.32 4.71 67600 4.73 01/15/09 12:00 4.73 5.17 4.64 52900 5.1 Jan 09 week 2.. |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open txt file 2. ctrl-h open 'replace' window *set "Replace Unit" to "Line" *set "Replace Scope" to "Paragraph" *set "Replace with Pattern": --click 'Setting' page: *in 'Paragraph delimiters' frame, Check option of "fixed para lines", and enter "5,5,5,5,5,5,5,4.." at right(week 1 has 5 days, week2 has 5 days ..) --click 'Advanced' page: *set "Run following for each matched Unit": *set insert end text: 3.click replace,done! |
| Download Script: scripts/335.rst.zip |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |