Month indicator from Year of data string

[JasonKaufman]

I am using Crystal XI

I am wanting to create a report that takes the db string of data and looks at each section of the string and determines the numerical month value of the section.
So when it looks at the data below, it would see the first section (789.6) and indicate that this is month 01 and so forth for all 12 months.

Keep in mind that once this formula is created, I will be wanting to create a new header with this new month formula so all product sold in that month will appear.

789.6;211.5;479.4;1170.3;944.7;1099.8;1198.5;1123.2;1641.6;3542.4;187.2;259.2;0


This is the formula that I am using now to pull out the data
(local stringvar array x;
x:=split({oe_hist_prod.dollars-shipped}, ";");
(x[1])

Thanks for the help!

 

[JasonKaufman]

This was errantly placed in Access section...
question has been properly reposted in Crystal forum.