I need to create a report from data in a csv file the contents of which is given below. I want to be able to arrange this in columns as follows:
Day Nov-06 Day Dec-06
1 <blank> 1 0.00
2 <blank> 2 0.00
.. <blank> .. 0.00
20 <blank> 20 10.00
29 0.00 ...
30 0.00 ...
31 <blank> 31 10.00
Reading the data from below and having stripped out the text from .. Market Card Results .... Stock: 0.00.
I found this rather daunting not having wrote a crystal report from csv file before.
Any help will be much appreciated
thanks
xhp95
Market Card Results
Daily Breakdown - Total AH/USD (LME): Forward FX Position, Shown in Lots and Square Card. All physicals are included.
Stock: 0.00
Day,Nov-06 Cum Pos
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16,
17,
18,
19,
20,
21,
22,
23,
24,
25,
26,
27,
28,
29,0.00
30,0.00
31,
Total,
Day,Dec-06 Cum Pos
1,0.00
2,0.00
3,0.00
4,0.00
5,0.00
6,0.00
7,0.00
8,0.00
9,0.00
10,0.00
11,0.00
12,0.00
13,0.00
14,0.00
15,0.00
16,0.00
17,0.00
18,0.00
19,0.00
20,10.00
21,10.00
22,10.00
23,10.00
24,10.00
25,10.00
26,10.00
27,10.00
28,10.00
29,10.00
30,10.00
31,10.00
Total,