hi there,
This is a biggie and a tricky one…
OK.
I am building a drink unit calculator. Well actually, i built a drink unit calculator with static data but now it needs to be dynamic. Previously i had used a load of arrays that just sat in the swf. Basically a user selects from a combo box of different alcohol types (ale, champagne, cider etc) then selects a drink (i.e. ale 1, ale 2 etc) from that type then selects a measure (i.e. pint draught, bottle 275ml etc). they then select how many they had and the flash works out how many units they drank…
here is how i was storing the data… As you can see, just a load of arrays, nice n simple, nice n easy to manipulate…
(i won’t go in to details on the manipulation code as it probably isn’t relavant)
var keyArr:Array = [
"name",
"pint bottle",
"pint draught",
"bottle 335ml",
"bottle 330ml",
"glass 284ml",
"cans 500ml",
"swingtop 500ml",
"bottle 275ml",
"bottle 250ml",
"bottle 750ml",
"measure 35ml",
"quart 187ml",
"largeglass 150ml",
"smallglass 100ml"
];
var Ale:Array = [ ["Smithwicks", 0, 3.8, 0, 4.0, 3.8, 4.0, 0, 0, 0, 0, 0, 0, 0, 0],["Bass", 0, 3.4, 0, 0, 3.4, 3.8, 0, 0, 0, 0, 0, 0, 0, 0],["Beamish Ale", 4.2, 0, 0, 4.2, 4.2, 0, 0, 0, 0, 0, 0, 0, 0, 0],["MacArdles", 3.4, 0, 0, 0, 3.4, 4.0, 0, 0, 0, 0, 0, 0, 0, 0],["Smithwicks Barley", 0, 0, 0, 5.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Other Ale", 3.8, 3.8, 3.8, 3.8, 3.8, 3.8, 0, 3.8, 3.8, 0, 0, 0, 0, 0],["Beamish Stout", 0, 4.2, 0, 0, 4.2, 4.2, 0, 0, 0, 0, 0, 0, 0, 0],["Guinness", 0, 4.2, 0, 4.3, 4.2, 4.3, 0, 0, 0, 0, 0, 0, 0, 0],["Murphy's Irish Stout", 0, 4.0, 0, 0, 4.0, 4.0, 0, 0, 0, 0, 0, 0, 0, 0],["Other Stout", 0, 4.3, 0, 4.3, 4.3, 4.3, 0, 0, 0, 0, 0, 0, 0, 0] ];
var Champagne:Array = [ ["Don't Know", 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0],["Dom Perignon", 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0],["Moet & Chandon NV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0],["Moet & Chandon NV Rose", 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0],["Moet & Chandon Vintage", 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0],["West Coast Cooler", 0, 0, 0, 0, 0, 0, 0, 0, 4.0, 4.0, 0, 0, 0, 0] ];
var Cider:Array = [ ["Golden Scrumpy", 0, 0, 0, 0, 0, 6.0, 0, 0, 0, 0, 0, 0, 0, 0],["Bulmers", 4.5, 4.5, 0, 4.5, 0, 4.5, 0, 0, 0, 0, 0, 0, 0, 0],["Crofter's Cider", 0, 0, 0, 4.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Samsons", 0, 0, 0, 0, 0, 6.0, 0, 0, 0, 0, 0, 0, 0, 0],["Linden Village", 0, 0, 0, 0, 0, 6.0, 0, 0, 0, 0, 0, 0, 0, 0],["Other Cider", 4.5, 4.5, 4.5, 4.5, 4.5, 4.5, 0, 4.5, 4.5, 0, 0, 0, 0, 0] ];
var Lager:Array = [ ["Amstel", 0, 4.3, 0, 4.3, 4.3, 4.3, 0, 0, 0, 0, 0, 0, 0, 0],["Beck's", 0, 0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Brahma", 0, 0, 4.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Budweiser", 0, 4.4, 0, 4.3, 4.4, 4.3, 0, 0, 0, 0, 0, 0, 0, 0],["Carling Black Label", 4.1, 4.1, 4.1, 0, 0, 4.1, 0, 0, 0, 0, 0, 0, 0, 0],["Carlsberg", 0, 4.4, 0, 4.3, 4.4, 4.3, 0, 0, 0, 0, 0, 0, 0, 0],["Coors Light", 0, 4.3, 0, 4.3, 4.3, 4.3, 0, 0, 0, 0, 0, 0, 0, 0],["Foster's", 0, 4.3, 4.3, 0, 0, 4.3, 0, 0, 0, 0, 0, 0, 0, 0],["Foster's Ice", 0, 0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Grolsch", 0, 0, 0, 5.0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0],["Harp", 0, 4.2, 0, 4.3, 4.2, 4.3, 0, 0, 0, 0, 0, 0, 0, 0],["Heineken", 0, 4.3, 0, 4.3, 4.3, 4.3, 0, 0, 0, 0, 0, 0, 0, 0],["Kronenbourg", 0, 5.0, 0, 0, 0, 5.0, 0, 0, 5.0, 0, 0, 0, 0, 0],["Miller Genuine Draft", 4.4, 0, 0, 4.4, 0, 4.4, 0, 0, 0, 0, 0, 0, 0, 0],["Rolling Rock", 0, 0, 0, 4.6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Satzenbrau", 0, 0, 0, 5.5, 0, 5.5, 0, 0, 0, 0, 0, 0, 0, 0],["Staropramen", 0, 0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Stella Artois", 0, 5.2, 0, 5.1, 5.2, 5.1, 0, 0, 0, 0, 0, 0, 0, 0],["Tennent's", 0, 3.7, 0, 0, 3.7, 4.0, 0, 0, 0, 0, 0, 0, 0, 0],["Other Lager", 4.3, 4.3, 4.3, 4.3, 4.3, 4.3, 0, 4.3, 4.3, 0, 0, 0, 0, 0],["Leffe Brune", 0, 0, 0, 6.6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Hoegaarden", 0, 0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Leffe Blonde", 0, 0, 0, 6.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],["Other Beer", 6.5, 6.5, 6.5, 6.5, 6.5, 6.5, 0, 6.5, 6.5, 0, 0, 0, 0, 0] ];
var Liqueurs:Array = [ ["Bacardi Twist", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0],["Baileys", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17.0, 0, 0, 0],["Cooymans Peach Schnapps", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20.0, 0, 0, 0],["Dom Benedictine", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40, 0, 0, 0],["Grand Marnier", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40.0, 0, 0, 0],["Jansen Crème de Menthe", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25.0, 0, 0, 0],["Malibu", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21.0, 0, 0, 0],["Midori", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20.0, 0, 0, 0],["Mulligan Liqeur", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35.0, 0, 0, 0],["Pernod", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40.0, 0, 0, 0],["Sambuca Borsci", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40.0, 0, 0, 0],["Tia Maria", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26.5, 0, 0, 0],["Other Liqueurs", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20.0, 0, 0, 0] ];
var FortifiedWine:Array = [ ["Sandeman 3*", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0],["Sandeman 5*", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0],["Sandeman Cream", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 0, 0],["Sandeman LBV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0],["Sandeman Madeira", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0],["Don't Know Port", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0], ["Martini", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17.5, 0, 0, 0],["Noilly Prat", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18.0, 0, 0, 0],["Other Vermouth", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17.5, 0, 0, 0] ];
var Wine:Array = [ ["11.0% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.0, 0, 11.0, 11.0, 11.0],["11.5% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.5, 0, 11.5, 11.5, 11.5],["12.0% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 12.0, 0, 12.0, 12.0, 12.0],["12.5% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 12.5, 0, 12.5, 12.5, 12.5],["13.0% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 13.0, 0, 13.0, 13.0, 13.0],["13.5% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 13.5, 0, 13.5, 13.5, 13.5],["14.0%", 0, 0, 0, 0, 0, 0, 0, 0, 0, 14.0, 0, 14.0, 14.0, 14.0],["14.5% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 14.5, 0, 14.5, 14.5, 14.5],["15.0% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0],[">15.0% ABV", 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0],["Other Wine", 0, 0, 0, 0, 0, 0, 0, 0, 0, 12.5, 0, 12.5, 12.5, 12.5] ];
It was all working fine, however, as i mentioned, it now needs to be dynamic, i.e. the data has to be updateable in a DB, and then publishable to a text file that i need to get into flash…
Unfortunately flash can’t pull in external arrays automatically, so my idea was to pull in the data as one huge string from the dynamically generated text file, then split it apart and build it back up into arrays within flash…
so first off i changed the way the data is published to make one huge string: (keyArr isn’t included as that is static and won’t be changing and i have spaced things out so you can see what the hell is going on)
bigbast=***Ale= Smithwicks, 0, 3.8, 0, 4.0, 3.8, 4.0, 0, 0, 0, 0, 0, 0, 0, 0*Bass, 0, 3.4, 0, 0, 3.4, 3.8, 0, 0, 0, 0, 0, 0, 0, 0*Beamish Ale, 4.2, 0, 0, 4.2, 4.2, 0, 0, 0, 0, 0, 0, 0, 0, 0*MacArdles, 3.4, 0, 0, 0, 3.4, 4.0, 0, 0, 0, 0, 0, 0, 0, 0*Smithwicks Barley, 0, 0, 0, 5.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Don't Know, 3.8, 3.8, 3.8, 3.8, 3.8, 3.8, 0, 3.8, 3.8, 0, 0, 0, 0, 0*Beamish Stout, 0, 4.2, 0, 0, 4.2, 4.2, 0, 0, 0, 0, 0, 0, 0, 0*Guinness, 0, 4.2, 0, 4.3, 4.2, 4.3, 0, 0, 0, 0, 0, 0, 0, 0*Murphy's Irish Stout, 0, 4.0, 0, 0, 4.0, 4.0, 0, 0, 0, 0, 0, 0, 0, 0*Don't Know, 0, 4.3, 0, 4.3, 4.3, 4.3, 0, 0, 0, 0, 0, 0, 0, 0 ;
***Champagne= Don't Know, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0*Dom Perignon, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0*Moet and Chandon NV, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0*Moet and Chandon NV Rose, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0*Moet and Chandon Vintage, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0*West Coast Cooler, 0, 0, 0, 0, 0, 0, 0, 0, 4.0, 4.0, 0, 0, 0, 0 ;
***Cider= Golden Scrumpy, 0, 0, 0, 0, 0, 6.0, 0, 0, 0, 0, 0, 0, 0, 0*Bulmers, 4.5, 4.5, 0, 4.5, 0, 4.5, 0, 0, 0, 0, 0, 0, 0, 0*Crofter's Cider, 0, 0, 0, 4.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Samsons, 0, 0, 0, 0, 0, 6.0, 0, 0, 0, 0, 0, 0, 0, 0*Linden Village, 0, 0, 0, 0, 0, 6.0, 0, 0, 0, 0, 0, 0, 0, 0*Don't Know, 4.5, 4.5, 4.5, 4.5, 4.5, 4.5, 0, 4.5, 4.5, 0, 0, 0, 0, 0 ;
***Lager= Amstel, 0, 4.3, 0, 4.3, 4.3, 4.3, 0, 0, 0, 0, 0, 0, 0, 0*Beck's, 0, 0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Brahma, 0, 0, 4.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Budweiser, 0, 4.4, 0, 4.3, 4.4, 4.3, 0, 0, 0, 0, 0, 0, 0, 0*Carling Black Label, 4.1, 4.1, 4.1, 0, 0, 4.1, 0, 0, 0, 0, 0, 0, 0, 0*Carlsberg, 0, 4.4, 0, 4.3, 4.4, 4.3, 0, 0, 0, 0, 0, 0, 0, 0*Coors Light, 0, 4.3, 0, 4.3, 4.3, 4.3, 0, 0, 0, 0, 0, 0, 0, 0*Foster's, 0, 4.3, 4.3, 0, 0, 4.3, 0, 0, 0, 0, 0, 0, 0, 0*Foster's Ice, 0, 0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Grolsch, 0, 0, 0, 5.0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0*Harp, 0, 4.2, 0, 4.3, 4.2, 4.3, 0, 0, 0, 0, 0, 0, 0, 0*Heineken, 0, 4.3, 0, 4.3, 4.3, 4.3, 0, 0, 0, 0, 0, 0, 0, 0*Kronenbourg, 0, 5.0, 0, 0, 0, 5.0, 0, 0, 5.0, 0, 0, 0, 0, 0*Miller Genuine Draft, 4.4, 0, 0, 4.4, 0, 4.4, 0, 0, 0, 0, 0, 0, 0, 0*Rolling Rock, 0, 0, 0, 4.6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Satzenbrau, 0, 0, 0, 5.5, 0, 5.5, 0, 0, 0, 0, 0, 0, 0, 0*Staropramen, 0, 0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Stella Artois, 0, 5.2, 0, 5.1, 5.2, 5.1, 0, 0, 0, 0, 0, 0, 0, 0*Tennent's, 0, 3.7, 0, 0, 3.7, 4.0, 0, 0, 0, 0, 0, 0, 0, 0*Don't Know, 4.3, 4.3, 4.3, 4.3, 4.3, 4.3, 0, 4.3, 4.3, 0, 0, 0, 0, 0*Leffe Brune, 0, 0, 0, 6.6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Hoegaarden, 0, 0, 0, 5.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Leffe Blonde, 0, 0, 0, 6.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0*Don't Know, 6.5, 6.5, 6.5, 6.5, 6.5, 6.5, 0, 6.5, 6.5, 0, 0, 0, 0, 0 ;
***Liqueurs= Bacardi Twist, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0*Baileys, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17.0, 0, 0, 0*Cooymans Peach Schnapps, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20.0, 0, 0, 0*Dom Benedictine, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40, 0, 0, 0*Grand Marnier, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40.0, 0, 0, 0*Irish Spirits, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30.0, 0, 0, 0*Jansen Crème de Menthe, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25.0, 0, 0, 0*Malibu, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21.0, 0, 0, 0*Midori, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20.0, 0, 0, 0*Mulligan Liqeur, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35.0, 0, 0, 0*Pernod, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40.0, 0, 0, 0*Sambuca Borsci, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40.0, 0, 0, 0*Tia Maria, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26.5, 0, 0, 0*Don't Know, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20.0, 0, 0, 0
***FortifiedWine= Sandeman 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0*Sandeman 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0*Sandeman Cream, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 0, 0*Sandeman LBV, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0*Sandeman Madeira, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0*Don't Know, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22.0, 0, 0, 0*Vermouth= Martini, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17.5, 0, 0, 0*Noilly Prat, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18.0, 0, 0, 0*Don't Know, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17.5, 0, 0, 0 ;
***Wine= <11.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.0, 0, 11.0, 11.0, 11.0*11.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.5, 0, 11.5, 11.5, 11.5*12.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12.0, 0, 12.0, 12.0, 12.0*12.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12.5, 0, 12.5, 12.5, 12.5*13.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13.0, 0, 13.0, 13.0, 13.0*13.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13.5, 0, 13.5, 13.5, 13.5*14.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14.0, 0, 14.0, 14.0, 14.0*14.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14.5, 0, 14.5, 14.5, 14.5*15.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15.0, 0, 15.0, 15.0, 15.0*>15.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, >15.0, 0, >15.0, >15.0, >15.0*Don't Know, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12.5, 0, 12.5, 12.5, 12.5 ;
then i set about splitting the string down and building it back up…
stop();
var XXXdrinkArr:Array = bigbast.split("***")
///this array is all the different categories of drink
//trace(XXXdrinkArr)
/// start of loop
var XXXtempdrink:Array
for (i=1; i<XXXdrinkArr.length; i++) {
//changing XXXdrinkArr* lets you choose the type of drink to split
var XXXdrinktype:Array = XXXdrinkArr*.split("=")
//XXXdrinktype[0] = drink type
//XXXdrinktype[1] = all drink data for specific drink type
var alchtype = XXXdrinktype[0]
trace ("alchtype = " + alchtype)
//splitting XXXdrinktype at 1 gives us the data for a certain drink type
var XXXdrinks:Array = XXXdrinktype[1].split("*")
//loop round XXXdrinks for each drink - j - within a certain type
for (j=0; j<XXXdrinks.length; j++) {
//this var is the actual drink + data line
//trace(alchtype + "next drink data =" + XXXdrinks[j])
//split the drink data into component parts
var XXXSepdrink:Array = XXXdrinks[j].split(",")
//XXXSepdrink[0] is then added to the start of a new array
var XXXtempdrink:Array = XXXSepdrink[0]
//trace ("drink name = " + XXXtempdrink)
for (k=1; k<XXXSepdrink.length; k++) {
XXXtempdrink = XXXtempdrink.concat(XXXSepdrink[k])
}
var alchtype:Array = alchtype.concat(XXXtempdrink)
trace ("FINAL DRINK ARRAY = " + alchtype)
//trace(alchtype.length)
}
trace("********************Loop end*******************")
}
And it sort of works. it breaks everything down and then builds it back up. However the final array for each drink type doesn’t seem to be separated correctly and i can’t manipulate it. My brain hurts and i can’t work out how to separate / manipulate it or even if i am doing it fundamently right in the first place.
Have i gone totally the wrong way here? Is what i want to do even possible? Or is there a much easier way of doing it?
I was thinking perhaps it would have been easier to publish it out the db as an xml file???
Thanks in advance for any help!
graham
