please help me with this table
in this table i should drop all, except only first day of quarter, and if first day is missing it should be replaced by second date
Code:
01jan2008 23.17 02jan2008 22.49 03jan2008 23.94 04jan2008 25.71 28mar2008 25.61 31mar2008 22.68 01apr2008 23.43 02apr2008 23.21 03apr2008 22.45 04apr2008 22.42 07apr2008 22.36 08apr2008 22.81 09apr2008 21.98 10apr2008 23.46 11apr2008 23.82 14apr2008 22.78 15apr2008 21.58 19jun2008 22.87 20jun2008 22.64 23jun2008 22.42 24jun2008 21.14 25jun2008 23.93 26jun2008 23.44 27jun2008 23.95 30jun2008 23.65 01jul2008 25.92 02jul2008 24.78 03jul2008 04jul2008 25.78 07jul2008 23.15 08jul2008 25.23 09jul2008 25.59 10jul2008 27.49 11jul2008 28.48 14jul2008 28.54 15jul2008 33.85 22sep2008 35.72 23sep2008 35.19 24sep2008 32.82 25sep2008 34.74 26sep2008 46.72 29sep2008 39.39 30sep2008 39.81 01oct2008 45.26 02oct2008 45.14 03oct2008 52.05 06oct2008 53.68 07oct2008 57.53 08oct2008 63.92 09oct2008 69.95 10oct2008 54.99 13oct2008 55.13 14oct2008 ... and other years
23.17 | 01jan2008 |
22.68 | 01apr2008 |
23.65 | 01jul2008 |
39.81 | 01oct2008 |
etc | 01jan2009 |
Comment