Split big string and set in globalevaribales

 

Hi guys 

I have string i want to set these variables in Globalvariable after the split '

example =


SLXAUUSD60:1506.33000            =          SLXAUUSD60  1506.33000



SLXAUUSD60:1506.33000-SLXAUUSD5:1502.10000-SLXAUUSD43200:0.00000-SLXAUUSD30:1505.57000-SLXAUUSD240:0.00000-SLXAUUSD15:1501.83750-SLXAUUSD1440:0.00000-SLXAUUSD10080:0.00000-SLWTI60:0.00000-SLWTI5:0.00000-SLWTI43200:0.00000-SLWTI30:59.34000-SLWTI240:62.28000-SLWTI15:0.00000-SLWTI1440:0.00000-SLWTI10080:0.00000-SLUSDZAR60:14.69600-SLUSDZAR5:0.00000-SLUSDZAR43200:0.00000-SLUSDZAR30:14.72350-SLUSDZAR240:0.00000-SLUSDZAR15:14.71550-SLUSDZAR1440:0.00000-SLUSDZAR10080:15.44020-SLUSDJPY60:108.20500-SLUSDJPY5:0.00000-SLUSDJPY43200:108.80900-SLUSDJPY30:0.00000-SLUSDJPY240:108.34600-SLUSDJPY15:0.00000-SLUSDJPY1440:0.00000-SLUSDJPY10080:0.00000-SLUSDCHF60:0.00000-SLUSDCHF5:0.00000-SLUSDCHF43200:1.01850-SLUSDCHF30:0.00000-SLUSDCHF240:0.00000-SLUSDCHF15:0.99300-SLUSDCHF1440:0.00000-SLUSDCHF10080:0.00000-SLUSDCAD60:0.00000-SLUSDCAD5:1.32480-SLUSDCAD43200:1.34100-SLUSDCAD30:1.32440-SLUSDCAD240:0.00000-SLUSDCAD15:0.00000-SLUSDCAD1440:0.00000-SLUSDCAD10080:0.00000-SLNZDUSD60:0.00000-SLNZDUSD5:0.63580-SLNZDUSD43200:0.00000-SLNZDUSD30:0.00000-SLNZDUSD240:0.63790-SLNZDUSD15:0.00000-SLNZDUSD1440:0.63620-SLNZDUSD10080:0.67610-SLNZDJPY60:0.00000-SLNZDJPY5:0.00000-SLNZDJPY43200:71.88600-SLNZDJPY30:68.75300-SLNZDJPY240:0.00000-SLNZDJPY15:68.75370-SLNZDJPY1440:0.00000-SLNZDJPY10080:0.00000-SLNZDCHF60:0.00000-SLNZDCHF5:0.63120-SLNZDCHF43200:0.65670-SLNZDCHF30:0.63130-SLNZDCHF240:0.00000-SLNZDCHF15:0.00000-SLNZDCHF1440:0.00000-SLNZDCHF10080:0.66460-SLNZDCAD60:0.00000-SLNZDCAD5:0.00000-SLNZDCAD43200:0.86940-SLNZDCAD30:0.84200-SLNZDCAD240:0.00000-SLNZDCAD15:0.84190-SLNZDCAD1440:0.84550-SLNZDCAD10080:0.00000-SLGBPUSD60:0.00000-SLGBPUSD5:0.00000-SLGBPUSD43200:1.27670-SLGBPUSD30:1.25030-SLGBPUSD240:0.00000-SLGBPUSD15:1.25030-SLGBPUSD1440:0.00000-SLGBPUSD10080:0.00000-SLGBPNZD60:1.96880-SLGBPNZD5:0.00000-SLGBPNZD43200:0.00000-SLGBPNZD30:1.96910-SLGBPNZD240:0.00000-SLGBPNZD15:1.96580-SLGBPNZD1440:0.00000-SLGBPNZD10080:0.00000-SLGBPJPY60:135.32800-SLGBPJPY5:0.00000-SLGBPJPY43200:141.77100-SLGBPJPY30:135.31200-SLGBPJPY240:0.00000-SLGBPJPY15:0.00000-SLGBPJPY1440:0.00000-SLGBPJPY10080:0.00000-SLGBPCHF60:1.24280-SLGBPCHF5:0.00000-SLGBPCHF43200:1.33520-SLGBPCHF30:1.24270-SLGBPCHF240:0.00000-SLGBPCHF15:1.24190-SLGBPCHF1440:0.00000-SLGBPCHF10080:1.31630-SLGBPCAD60:1.65580-SLGBPCAD5:0.00000-SLGBPCAD43200:1.75950-SLGBPCAD30:1.65580-SLGBPCAD240:0.00000-SLGBPCAD15:1.65710-SLGBPCAD1440:0.00000-SLGBPCAD10080:0.00000-SLGBPAUD60:1.82080-SLGBPAUD5:1.82030-SLGBPAUD43200:0.00000-SLGBPAUD30:1.82140-SLGBPAUD240:0.00000-SLGBPAUD15:0.00000-SLGBPAUD1440:0.00000-SLGBPAUD10080:0.00000-SLEURUSD60:0.00000-SLEURUSD5:1.10740-SLEURUSD43200:1.12900-SLEURUSD30:0.00000-SLEURUSD240:0.00000-SLEURUSD15:0.00000-SLEURUSD1440:0.00000-SLEURUSD10080:1.11340-SLEURNZD60:1.74360-SLEURNZD5:0.00000-SLEURNZD43200:0.00000-SLEURNZD30:1.74240-SLEURNZD240:0.00000-SLEURNZD15:1.74180-SLEURNZD1440:1.74640-SLEURNZD10080:0.00000-SLEURJPY60:119.75900-SLEURJPY5:0.00000-SLEURJPY43200:123.34800-SLEURJPY30:119.75700-SLEURJPY240:0.00000-SLEURJPY15:0.00000-SLEURJPY1440:0.00000-SLEURJPY10080:0.00000-SLEURGBP60:0.00000-SLEURGBP5:0.00000-SLEURGBP43200:0.00000-SLEURGBP30:0.00000-SLEURGBP240:0.88690-SLEURGBP15:0.00000-SLEURGBP1440:0.00000-SLEURGBP10080:0.90310-SLEURCHF60:0.00000-SLEURCHF5:0.00000-SLEURCHF43200:1.12930-SLEURCHF30:1.09970-SLEURCHF240:0.00000-SLEURCHF15:1.09970-SLEURCHF1440:0.00000-SLEURCHF10080:1.10900-SLEURCAD60:1.46680-SLEURCAD5:0.00000-SLEURCAD43200:1.53060-SLEURCAD30:1.46660-SLEURCAD240:0.00000-SLEURCAD15:0.00000-SLEURCAD1440:0.00000-SLEURCAD10080:1.47220-SLEURAUD60:0.00000-SLEURAUD5:0.00000-SLEURAUD43200:0.00000-SLEURAUD30:0.00000-SLEURAUD240:0.00000-SLEURAUD15:0.00000-SLEURAUD1440:0.00000-SLEURAUD10080:0.00000-SLCHFJPY60:0.00000-SLCHFJPY5:0.00000-SLCHFJPY43200:0.00000-SLCHFJPY30:0.00000-SLCHFJPY240:108.94300-SLCHFJPY15:0.00000-SLCHFJPY1440:0.00000-SLCHFJPY10080:0.00000-SLCADJPY60:0.00000-SLCADJPY5:0.00000-SLCADJPY43200:82.23500-SLCADJPY30:0.00000-SLCADJPY240:0.00000-SLCADJPY15:81.67100-SLCADJPY1440:0.00000-SLCADJPY10080:82.20500-SLCADCHF60:0.00000-SLCADCHF5:0.75000-SLCADCHF43200:0.76060-SLCADCHF30:0.00000-SLCADCHF240:0.00000-SLCADCHF15:0.74990-SLCADCHF1440:0.00000-SLCADCHF10080:0.00000-SLBRENT60:65.39000-SLBRENT5:0.00000-SLBRENT43200:0.00000-SLBRENT30:65.39000-SLBRENT240:66.47000-SLBRENT15:0.00000-SLBRENT1440:0.00000-SLBRENT10080:0.00000-SLAUDUSD60:0.00000-SLAUDUSD5:0.68670-SLAUDUSD43200:0.00000-SLAUDUSD30:0.00000-SLAUDUSD240:0.00000-SLAUDUSD15:0.00000-SLAUDUSD1440:0.68830-SLAUDUSD10080:0.00000-SLAUDNZD60:0.00000-SLAUDNZD5:0.00000-SLAUDNZD43200:0.00000-SLAUDNZD30:1.08020-SLAUDNZD240:1.08200-SLAUDNZD15:1.08020-SLAUDNZD1440:0.00000-SLAUDNZD10080:0.00000-SLAUDJPY60:74.27300-SLAUDJPY5:0.00000-SLAUDJPY43200:0.00000-SLAUDJPY30:0.00000-SLAUDJPY240:0.00000-SLAUDJPY15:0.00000-SLAUDJPY1440:0.00000-SLAUDJPY10080:0.00000-SLAUDCHF60:0.00000-SLAUDCHF5:0.00000-SLAUDCHF43200:0.68710-SLAUDCHF30:0.68180-SLAUDCHF240:0.00000-SLAUDCHF15:0.00000-SLAUDCHF1440:0.00000-SLAUDCHF10080:0.00000-SLAUDCAD60:0.90950-SLAUDCAD5:0.90970-SLAUDCAD43200:0.00000-SLAUDCAD30:0.90970-SLAUDCAD240:0.00000-SLAUDCAD15:0.90970-SLAUDCAD1440:0.91090-SLAUDCAD10080:0.00000-BLXAUUSD60:0.00000-BLXAUUSD5:0.00000-BLXAUUSD43200:1424.15000-BLXAUUSD30:0.00000-BLXAUUSD240:1500.57000-BLXAUUSD15:0.00000-BLXAUUSD1440:1487.88000-BLXAUUSD10080:1363.02000-BLWTI60:59.19000-BLWTI5:0.00000-BLWTI43200:0.00000-BLWTI30:59.14000-BLWTI240:56.73000-BLWTI15:59.15500-BLWTI1440:55.16000-BLWTI10080:55.19000-BLUSDZAR60:0.00000-BLUSDZAR5:0.00000-BLUSDZAR43200:0.00000-BLUSDZAR30:14.68970-BLUSDZAR240:0.00000-BLUSDZAR15:14.69060-BLUSDZAR1440:0.00000-BLUSDZAR10080:13.94790-BLUSDJPY60:0.00000-BLUSDJPY5:108.11700-BLUSDJPY43200:0.00000-BLUSDJPY30:0.00000-BLUSDJPY240:0.00000-BLUSDJPY15:108.11500-BLUSDJPY1440:106.65700-BLUSDJPY10080:0.00000-BLUSDCHF60:0.99270-BLUSDCHF5:0.99290-BLUSDCHF43200:0.00000-BLUSDCHF30:0.99240-BLUSDCHF240:0.99200-BLUSDCHF15:0.99290-BLUSDCHF1440:0.98760-BLUSDCHF10080:0.97940-BLUSDCAD60:0.00000-BLUSDCAD5:0.00000-BLUSDCAD43200:0.00000-BLUSDCAD30:0.00000-BLUSDCAD240:0.00000-BLUSDCAD15:0.00000-BLUSDCAD1440:1.31610-BLUSDCAD10080:0.00000-BLNZDUSD60:0.63240-BLNZDUSD5:0.00000-BLNZDUSD43200:0.00000-BLNZDUSD30:0.00000-BLNZDUSD240:0.63240-BLNZDUSD15:0.00000-BLNZDUSD1440:0.00000-BLNZDUSD10080:0.00000-BLNZDJPY60:68.62300-BLNZDJPY5:0.00000-BLNZDJPY43200:0.00000-BLNZDJPY30:0.00000-BLNZDJPY240:68.43700-BLNZDJPY15:0.00000-BLNZDJPY1440:0.00000-BLNZDJPY10080:67.34800-BLNZDCHF60:0.00000-BLNZDCHF5:0.00000-BLNZDCHF43200:0.00000-BLNZDCHF30:0.00000-BLNZDCHF240:0.62900-BLNZDCHF15:0.00000-BLNZDCHF1440:0.00000-BLNZDCHF10080:0.00000-BLNZDCAD60:0.00000-BLNZDCAD5:0.00000-BLNZDCAD43200:0.00000-BLNZDCAD30:0.84160-BLNZDCAD240:0.00000-BLNZDCAD15:0.00000-BLNZDCAD1440:0.00000-BLNZDCAD10080:0.00000-BLGBPUSD60:1.24450-BLGBPUSD5:0.00000-BLGBPUSD43200:0.00000-BLGBPUSD30:0.00000-BLGBPUSD240:1.24470-BLGBPUSD15:0.00000-BLGBPUSD1440:0.00000-BLGBPUSD10080:0.00000-BLGBPNZD60:0.00000-BLGBPNZD5:0.00000-BLGBPNZD43200:1.85330-BLGBPNZD30:0.00000-BLGBPNZD240:1.96360-BLGBPNZD15:0.00000-BLGBPNZD1440:1.94840-BLGBPNZD10080:1.91840-BLGBPJPY60:134.35100-BLGBPJPY5:135.14400-BLGBPJPY43200:0.00000-BLGBPJPY30:134.81150-BLGBPJPY240:134.20900-BLGBPJPY15:135.14200-BLGBPJPY1440:0.00000-BLGBPJPY10080:0.00000-BLGBPCHF60:1.23210-BLGBPCHF5:0.00000-BLGBPCHF43200:0.00000-BLGBPCHF30:0.00000-BLGBPCHF240:1.23200-BLGBPCHF15:0.00000-BLGBPCHF1440:1.22120-BLGBPCHF10080:1.19700-BLGBPCAD60:1.64780-BLGBPCAD5:0.00000-BLGBPCAD43200:0.00000-BLGBPCAD30:0.00000-BLGBPCAD240:1.64310-BLGBPCAD15:0.00000-BLGBPCAD1440:1.63440-BLGBPCAD10080:1.62540-BLGBPAUD60:1.81950-BLGBPAUD5:0.00000-BLGBPAUD43200:1.77170-BLGBPAUD30:0.00000-BLGBPAUD240:1.80560-BLGBPAUD15:0.00000-BLGBPAUD1440:1.80520-BLGBPAUD10080:1.78940-BLEURUSD60:0.00000-BLEURUSD5:0.00000-BLEURUSD43200:0.00000-BLEURUSD30:0.00000-BLEURUSD240:1.10360-BLEURUSD15:0.00000-BLEURUSD1440:0.00000-BLEURUSD10080:1.09270-BLEURNZD60:0.00000-BLEURNZD5:1.74140-BLEURNZD43200:0.00000-BLEURNZD30:1.74140-BLEURNZD240:1.73000-BLEURNZD15:1.74140-BLEURNZD1440:0.00000-BLEURNZD10080:0.00000-BLEURJPY60:119.45730-BLEURJPY5:0.00000-BLEURJPY43200:0.00000-BLEURJPY30:119.33570-BLEURJPY240:119.12530-BLEURJPY15:119.71500-BLEURJPY1440:0.00000-BLEURJPY10080:0.00000-BLEURGBP60:0.00000-BLEURGBP5:0.00000-BLEURGBP43200:0.85190-BLEURGBP30:0.88550-BLEURGBP240:0.00000-BLEURGBP15:0.00000-BLEURGBP1440:0.00000-BLEURGBP10080:0.00000-BLEURCHF60:0.00000-BLEURCHF5:0.00000-BLEURCHF43200:0.00000-BLEURCHF30:1.09920-BLEURCHF240:1.09160-BLEURCHF15:0.00000-BLEURCHF1440:0.00000-BLEURCHF10080:1.08910-BLEURCAD60:0.00000-BLEURCAD5:1.46610-BLEURCAD43200:0.00000-BLEURCAD30:0.00000-BLEURCAD240:1.45920-BLEURCAD15:0.00000-BLEURCAD1440:0.00000-BLEURCAD10080:0.00000-BLEURAUD60:1.61200-BLEURAUD5:0.00000-BLEURAUD43200:0.00000-BLEURAUD30:1.61200-BLEURAUD240:0.00000-BLEURAUD15:1.61200-BLEURAUD1440:0.00000-BLEURAUD10080:0.00000-BLCHFJPY60:0.00000-BLCHFJPY5:0.00000-BLCHFJPY43200:0.00000-BLCHFJPY30:108.88100-BLCHFJPY240:0.00000-BLCHFJPY15:0.00000-BLCHFJPY1440:0.00000-BLCHFJPY10080:0.00000-BLCADJPY60:81.61600-BLCADJPY5:0.00000-BLCADJPY43200:0.00000-BLCADJPY30:0.00000-BLCADJPY240:0.00000-BLCADJPY15:0.00000-BLCADJPY1440:80.50900-BLCADJPY10080:80.59900-BLCADCHF60:0.74960-BLCADCHF5:0.00000-BLCADCHF43200:0.00000-BLCADCHF30:0.00000-BLCADCHF240:0.74840-BLCADCHF15:0.00000-BLCADCHF1440:0.74600-BLCADCHF10080:0.72900-BLBRENT60:0.00000-BLBRENT5:0.00000-BLBRENT43200:0.00000-BLBRENT30:64.04000-BLBRENT240:0.00000-BLBRENT15:64.03000-BLBRENT1440:61.15000-BLBRENT10080:60.60000-BLAUDUSD60:0.68370-BLAUDUSD5:0.00000-BLAUDUSD43200:0.00000-BLAUDUSD30:0.00000-BLAUDUSD240:0.68340-BLAUDUSD15:0.00000-BLAUDUSD1440:0.00000-BLAUDUSD10080:0.00000-BLAUDNZD60:0.00000-BLAUDNZD5:1.07990-BLAUDNZD43200:0.00000-BLAUDNZD30:0.00000-BLAUDNZD240:0.00000-BLAUDNZD15:0.00000-BLAUDNZD1440:1.07090-BLAUDNZD10080:1.07060-BLAUDJPY60:73.95700-BLAUDJPY5:74.24100-BLAUDJPY43200:0.00000-BLAUDJPY30:0.00000-BLAUDJPY240:73.97000-BLAUDJPY15:74.23900-BLAUDJPY1440:0.00000-BLAUDJPY10080:73.36400-BLAUDCHF60:0.00000-BLAUDCHF5:0.00000-BLAUDCHF43200:0.00000-BLAUDCHF30:0.00000-BLAUDCHF240:0.00000-BLAUDCHF15:0.00000-BLAUDCHF1440:0.67750-BLAUDCHF10080:0.00000-BLAUDCAD60:0.00000-BLAUDCAD5:0.00000-BLAUDCAD43200:0.00000-BLAUDCAD30:0.00000-BLAUDCAD240:0.90570-BLAUDCAD15:0.00000-BLAUDCAD1440:0.00000-BLAUDCAD10080:0.89610-SLXAUUSD60:1506.33000-SLXAUUSD5:1502.10000-SLXAUUSD43200:0.00000-SLXAUUSD30:1505.57000-SLXAUUSD240:0.00000-SLXAUUSD15:1501.83750-SLXAUUSD1440:0.00000-SLXAUUSD10080:0.00000-SLWTI60:0.00000-SLWTI5:0.00000-SLWTI43200:0.00000-SLWTI30:59.34000-SLWTI240:62.28000-SLWTI15:0.00000-SLWTI1440:0.00000-SLWTI10080:0.00000-SLUSDZAR60:14.69600-SLUSDZAR5:0.00000-SLUSDZAR43200:0.00000-SLUSDZAR30:14.72350-SLUSDZAR240:0.00000-SLUSDZAR15:14.71550-SLUSDZAR1440:0.00000-SLUSDZAR10080:15.44020-SLUSDJPY60:108.20500-SLUSDJPY5:0.00000-SLUSDJPY43200:108.80900-SLUSDJPY30:0.00000-SLUSDJPY240:108.34600-SLUSDJPY15:0.00000-SLUSDJPY1440:0.00000-SLUSDJPY10080:0.00000-SLUSDCHF60:0.00000-SLUSDCHF5:0.00000-SLUSDCHF43200:1.01850-SLUSDCHF30:0.00000-SLUSDCHF240:0.00000-SLUSDCHF15:0.99300-SLUSDCHF1440:0.00000-SLUSDCHF10080:0.00000-SLUSDCAD60:0.00000-SLUSDCAD5:1.32480-SLUSDCAD43200:1.34100-SLUSDCAD30:1.32440-SLUSDCAD240:0.00000-SLUSDCAD15:0.00000-SLUSDCAD1440:0.00000-SLUSDCAD10080:0.00000-SLNZDUSD60:0.00000-SLNZDUSD5:0.63580-SLNZDUSD43200:0.00000-SLNZDUSD30:0.00000-SLNZDUSD240:0.63790-SLNZDUSD15:0.00000-SLNZDUSD1440:0.63620-SLNZDUSD10080:0.67610-SLNZDJPY60:0.00000-SLNZDJPY5:0.00000-SLNZDJPY43200:71.88600-SLNZDJPY30:68.75300-SLNZDJPY240:0.00000-SLNZDJPY15:68.75370-SLNZDJPY1440:0.00000-SLNZDJPY10080:0.00000-SLNZDCHF60:0.00000-SLNZDCHF5:0.63120-SLNZDCHF43200:0.65670-SLNZDCHF30:0.63130-SLNZDCHF240:0.00000-SLNZDCHF15:0.00000-SLNZDCHF1440:0.00000-SLNZDCHF10080:0.66460-SLNZDCAD60:0.00000-SLNZDCAD5:0.00000-SLNZDCAD43200:0.86940-SLNZDCAD30:0.84200-SLNZDCAD240:0.00000-SLNZDCAD15:0.84190-SLNZDCAD1440:0.84550-SLNZDCAD10080:0.00000-SLGBPUSD60:0.00000-SLGBPUSD5:0.00000-SLGBPUSD43200:1.27670-SLGBPUSD30:1.25030-SLGBPUSD240:0.00000-SLGBPUSD15:1.25030-SLGBPUSD1440:0.00000-SLGBPUSD10080:0.00000-SLGBPNZD60:1.96880-SLGBPNZD5:0.00000-SLGBPNZD43200:0.00000-SLGBPNZD30:1.96910-SLGBPNZD240:0.00000-SLGBPNZD15:1.96580-SLGBPNZD1440:0.00000-SLGBPNZD10080:0.00000-SLGBPJPY60:135.32800-SLGBPJPY5:0.00000-SLGBPJPY43200:141.77100-SLGBPJPY30:135.31200-SLGBPJPY240:0.00000-SLGBPJPY15:0.00000-SLGBPJPY1440:0.00000-SLGBPJPY10080:0.00000-SLGBPCHF60:1.24280-SLGBPCHF5:0.00000-SLGBPCHF43200:1.33520-SLGBPCHF30:1.24270-SLGBPCHF240:0.00000-SLGBPCHF15:1.24190-SLGBPCHF1440:0.00000-SLGBPCHF10080:1.31630-SLGBPCAD60:1.65580-SLGBPCAD5:0.00000-SLGBPCAD43200:1.75950-SLGBPCAD30:1.65580-SLGBPCAD240:0.00000-SLGBPCAD15:1.65710-SLGBPCAD1440:0.00000-SLGBPCAD10080:0.00000-SLGBPAUD60:1.82080-SLGBPAUD5:1.82030-SLGBPAUD43200:0.00000-SLGBPAUD30:1.82140-SLGBPAUD240:0.00000-SLGBPAUD15:0.00000-SLGBPAUD1440:0.00000-SLGBPAUD10080:0.00000-SLEURUSD60:0.00000-SLEURUSD5:1.10740-SLEURUSD43200:1.12900-SLEURUSD30:0.00000-SLEURUSD240:0.00000-SLEURUSD15:0.00000-SLEURUSD1440:0.00000-SLEURUSD10080:1.11340-SLEURNZD60:1.74360-SLEURNZD5:0.00000-SLEURNZD43200:0.00000-SLEURNZD30:1.74240-SLEURNZD240:0.00000-SLEURNZD15:1.74180-SLEURNZD1440:1.74640-SLEURNZD10080:0.00000-SLEURJPY60:119.75900-SLEURJPY5:0.00000-SLEURJPY43200:123.34800-SLEURJPY30:119.75700-SLEURJPY240:0.00000-SLEURJPY15:0.00000-SLEURJPY1440:0.00000-SLEURJPY10080:0.00000-SLEURGBP60:0.00000-SLEURGBP5:0.00000-SLEURGBP43200:0.00000-SLEURGBP30:0.00000-SLEURGBP240:0.88690-SLEURGBP15:0.00000-SLEURGBP1440:0.00000-SLEURGBP10080:0.90310-SLEURCHF60:0.00000-SLEURCHF5:0.00000-SLEURCHF43200:1.12930-SLEURCHF30:1.09970-SLEURCHF240:0.00000-SLEURCHF15:1.09970-SLEURCHF1440:0.00000-SLEURCHF10080:1.10900-SLEURCAD60:1.46680-SLEURCAD5:0.00000-SLEURCAD43200:1.53060-SLEURCAD30:1.46660-SLEURCAD240:0.00000-SLEURCAD15:0.00000-SLEURCAD1440:0.00000-SLEURCAD10080:1.47220-SLEURAUD60:0.00000-SLEURAUD5:0.00000-SLEURAUD43200:0.00000-SLEURAUD30:0.00000-SLEURAUD240:0.00000-SLEURAUD15:0.00000-SLEURAUD1440:0.00000-SLEURAUD10080:0.00000-SLCHFJPY60:0.00000-SLCHFJPY5:0.00000-SLCHFJPY43200:0.00000-SLCHFJPY30:0.00000-SLCHFJPY240:108.94300-SLCHFJPY15:0.00000-SLCHFJPY1440:0.00000-SLCHFJPY10080:0.00000-SLCADJPY60:0.00000-SLCADJPY5:0.00000-SLCADJPY43200:82.23500-SLCADJPY30:0.00000-SLCADJPY240:0.00000-SLCADJPY15:81.67100-SLCADJPY1440:0.00000-SLCADJPY10080:82.20500-SLCADCHF60:0.00000-SLCADCHF5:0.75000-SLCADCHF43200:0.76060-SLCADCHF30:0.00000-SLCADCHF240:0.00000-SLCADCHF15:0.74990-SLCADCHF1440:0.00000-SLCADCHF10080:0.00000-SLBRENT60:65.39000-SLBRENT5:0.00000-SLBRENT43200:0.00000-SLBRENT30:65.39000-SLBRENT240:66.47000-SLBRENT15:0.00000-SLBRENT1440:0.00000-SLBRENT10080:0.00000-SLAUDUSD60:0.00000-SLAUDUSD5:0.68670-SLAUDUSD43200:0.00000-SLAUDUSD30:0.00000-SLAUDUSD240:0.00000-SLAUDUSD15:0.00000-SLAUDUSD1440:0.68830-SLAUDUSD10080:0.00000-SLAUDNZD60:0.00000-SLAUDNZD5:0.00000-SLAUDNZD43200:0.00000-SLAUDNZD30:1.08020-SLAUDNZD240:1.08200-SLAUDNZD15:1.08020-SLAUDNZD1440:0.00000-SLAUDNZD10080:0.00000-SLAUDJPY60:74.27300-SLAUDJPY5:0.00000-SLAUDJPY43200:0.00000-SLAUDJPY30:0.00000-SLAUDJPY240:0.00000-SLAUDJPY15:0.00000-SLAUDJPY1440:0.00000-SLAUDJPY10080:0.00000-SLAUDCHF60:0.00000-SLAUDCHF5:0.00000-SLAUDCHF43200:0.68710-SLAUDCHF30:0.68180-SLAUDCHF240:0.00000-SLAUDCHF15:0.00000-SLAUDCHF1440:0.00000-SLAUDCHF10080:0.00000-SLAUDCAD60:0.90950-SLAUDCAD5:0.90970-SLAUDCAD43200:0.00000-SLAUDCAD30:0.90970-SLAUDCAD240:0.00000-SLAUDCAD15:0.90970-SLAUDCAD1440:0.91090-SLAUDCAD10080:0.00000-BLXAUUSD60:0.00000-BLXAUUSD5:0.00000-BLXAUUSD43200:1424.15000-BLXAUUSD30:0.00000-BLXAUUSD240:1500.57000-BLXAUUSD15:0.00000-BLXAUUSD1440:1487.88000-BLXAUUSD10080:1363.02000-BLWTI60:59.19000-BLWTI5:0.00000-BLWTI43200:0.00000-BLWTI30:59.14000-BLWTI240:56.73000-BLWTI15:59.15500-BLWTI1440:55.16000-BLWTI10080:55.19000-BLUSDZAR60:0.00000-BLUSDZAR5:0.00000-BLUSDZAR43200:0.00000-BLUSDZAR30:14.68970-BLUSDZAR240:0.00000-BLUSDZAR15:14.69060-BLUSDZAR1440:0.00000-BLUSDZAR10080:13.94790-BLUSDJPY60:0.00000-BLUSDJPY5:108.11700-BLUSDJPY43200:0.00000-BLUSDJPY30:0.00000-BLUSDJPY240:0.00000-BLUSDJPY15:108.11500-BLUSDJPY1440:106.65700-BLUSDJPY10080:0.00000-BLUSDCHF60:0.99270-BLUSDCHF5:0.99290-BLUSDCHF43200:0.00000-BLUSDCHF30:0.99240-BLUSDCHF240:0.99200-BLUSDCHF15:0.99290-BLUSDCHF1440:0.98760-BLUSDCHF10080:0.97940-BLUSDCAD60:0.00000-BLUSDCAD5:0.00000-BLUSDCAD43200:0.00000-BLUSDCAD30:0.00000-BLUSDCAD240:0.00000-BLUSDCAD15:0.00000-BLUSDCAD1440:1.31610-BLUSDCAD10080:0.00000-BLNZDUSD60:0.63240-BLNZDUSD5:0.00000-BLNZDUSD43200:0.00000-BLNZDUSD30:0.00000-BLNZDUSD240:0.63240-BLNZDUSD15:0.00000-BLNZDUSD1440:0.00000-BLNZDUSD10080:0.00000-BLNZDJPY60:68.62300-BLNZDJPY5:0.00000-BLNZDJPY43200:0.00000-BLNZDJPY30:0.00000-BLNZDJPY240:68.43700-BLNZDJPY15:0.00000-BLNZDJPY1440:0.00000-BLNZDJPY10080:67.34800-BLNZDCHF60:0.00000-BLNZDCHF5:0.00000-BLNZDCHF43200:0.00000-BLNZDCHF30:0.00000-BLNZDCHF240:0.62900-BLNZDCHF15:0.00000-BLNZDCHF1440:0.00000-BLNZDCHF10080:0.00000-BLNZDCAD60:0.00000-BLNZDCAD5:0.00000-BLNZDCAD43200:0.00000-BLNZDCAD30:0.84160-BLNZDCAD240:0.00000-BLNZDCAD15:0.00000-BLNZDCAD1440:0.00000-BLNZDCAD10080:0.00000-BLGBPUSD60:1.24450-BLGBPUSD5:0.00000-BLGBPUSD43200:0.00000-BLGBPUSD30:0.00000-BLGBPUSD240:1.24470-BLGBPUSD15:0.00000-BLGBPUSD1440:0.00000-BLGBPUSD10080:0.00000-BLGBPNZD60:0.00000-BLGBPNZD5:0.00000-BLGBPNZD43200:1.85330-BLGBPNZD30:0.00000-BLGBPNZD240:1.96360-BLGBPNZD15:0.00000-BLGBPNZD1440:1.94840-BLGBPNZD10080:1.91840-BLGBPJPY60:134.35100-BLGBPJPY5:135.14400-BLGBPJPY43200:0.00000-BLGBPJPY30:134.81150-BLGBPJPY240:134.20900-BLGBPJPY15:135.14200-BLGBPJPY1440:0.00000-BLGBPJPY10080:0.00000-BLGBPCHF60:1.23210-BLGBPCHF5:0.00000-BLGBPCHF43200:0.00000-BLGBPCHF30:0.00000-BLGBPCHF240:1.23200-BLGBPCHF15:0.00000-BLGBPCHF1440:1.22120-BLGBPCHF10080:1.19700-BLGBPCAD60:1.64780-BLGBPCAD5:0.00000-BLGBPCAD43200:0.00000-BLGBPCAD30:0.00000-BLGBPCAD240:1.64310-BLGBPCAD15:0.00000-BLGBPCAD1440:1.63440-BLGBPCAD10080:1.62540-BLGBPAUD60:1.81950-BLGBPAUD5:0.00000-BLGBPAUD43200:1.77170-BLGBPAUD30:0.00000-BLGBPAUD240:1.80560-BLGBPAUD15:0.00000-BLGBPAUD1440:1.80520-BLGBPAUD10080:1.78940-BLEURUSD60:0.00000-BLEURUSD5:0.00000-BLEURUSD43200:0.00000-BLEURUSD30:0.00000-BLEURUSD240:1.10360-BLEURUSD15:0.00000-BLEURUSD1440:0.00000-BLEURUSD10080:1.09270-BLEURNZD60:0.00000-BLEURNZD5:1.74140-BLEURNZD43200:0.00000-BLEURNZD30:1.74140-BLEURNZD240:1.73000-BLEURNZD15:1.74140-BLEURNZD1440:0.00000-BLEURNZD10080:0.00000-BLEURJPY60:119.45730-BLEURJPY5:0.00000-BLEURJPY43200:0.00000-BLEURJPY30:119.33570-BLEURJPY240:119.12530-BLEURJPY15:119.71500-BLEURJPY1440:0.00000-BLEURJPY10080:0.00000-BLEURGBP60:0.00000-BLEURGBP5:0.00000-BLEURGBP43200:0.85190-BLEURGBP30:0.88550-BLEURGBP240:0.00000-BLEURGBP15:0.00000-BLEURGBP1440:0.00000-BLEURGBP10080:0.00000-BLEURCHF60:0.00000-BLEURCHF5:0.00000-BLEURCHF43200:0.00000-BLEURCHF30:1.09920-BLEURCHF240:1.09160-BLEURCHF15:0.00000-BLEURCHF1440:0.00000-BLEURCHF10080:1.08910-BLEURCAD60:0.00000-BLEURCAD5:1.46610-BLEURCAD43200:0.00000-BLEURCAD30:0.00000-BLEURCAD240:1.45920-BLEURCAD15:0.00000-BLEURCAD1440:0.00000-BLEURCAD10080:0.00000-BLEURAUD60:1.61200-BLEURAUD5:0.00000-BLEURAUD43200:0.00000-BLEURAUD30:1.61200-BLEURAUD240:0.00000-BLEURAUD15:1.61200-BLEURAUD1440:0.00000-BLEURAUD10080:0.00000-BLCHFJPY60:0.00000-BLCHFJPY5:0.00000-BLCHFJPY43200:0.00000-BLCHFJPY30:108.88100-BLCHFJPY240:0.00000-BLCHFJPY15:0.00000-BLCHFJPY1440:0.00000-BLCHFJPY10080:0.00000-BLCADJPY60:81.61600-BLCADJPY5:0.00000-BLCADJPY43200:0.00000-BLCADJPY30:0.00000-BLCADJPY240:0.00000-BLCADJPY15:0.00000-BLCADJPY1440:80.50900-BLCADJPY10080:80.59900-BLCADCHF60:0.74960-BLCADCHF5:0.00000-BLCADCHF43200:0.00000-BLCADCHF30:0.00000-BLCADCHF240:0.74840-BLCADCHF15:0.00000-BLCADCHF1440:0.74600-BLCADCHF10080:0.72900-BLBRENT60:0.00000-BLBRENT5:0.00000-BLBRENT43200:0.00000-BLBRENT30:64.04000-BLBRENT240:0.00000-BLBRENT15:64.03000-BLBRENT1440:61.15000-BLBRENT10080:60.60000-BLAUDUSD60:0.68370-BLAUDUSD5:0.00000-BLAUDUSD43200:0.00000-BLAUDUSD30:0.00000-BLAUDUSD240:0.68340-BLAUDUSD15:0.00000-BLAUDUSD1440:0.00000-BLAUDUSD10080:0.00000-BLAUDNZD60:0.00000-BLAUDNZD5:1.07990-BLAUDNZD43200:0.00000-BLAUDNZD30:0.00000-BLAUDNZD240:0.00000-BLAUDNZD15:0.00000-BLAUDNZD1440:1.07090-BLAUDNZD10080:1.07060-BLAUDJPY60:73.95700-BLAUDJPY5:74.24100-BLAUDJPY43200:0.00000-BLAUDJPY30:0.00000-BLAUDJPY240:73.97000-BLAUDJPY15:74.23900-BLAUDJPY1440:0.00000-BLAUDJPY10080:73.36400-BLAUDCHF60:0.00000-BLAUDCHF5:0.00000-BLAUDCHF43200:0.00000-BLAUDCHF30:0.00000-BLAUDCHF240:0.00000-BLAUDCHF15:0.00000-BLAUDCHF1440:0.67750-BLAUDCHF10080:0.00000-BLAUDCAD60:0.00000-BLAUDCAD5:0.00000-BLAUDCAD43200:0.00000-BLAUDCAD30:0.00000-BLAUDCAD240:0.90570-BLAUDCAD15:0.00000-BLAUDCAD1440:0.00000-BLAUDCAD10080:0.89610

 
Hadi Ein Jafari:

Hi guys 

I have string i want to set these variables in Globalvariable after the split '

example =

SLXAUUSD60:1506.33000            =          SLXAUUSD60  1506.33000

Try this:

   string strData = "your string"
   string straData[];
   
   int iNumData = StringSplit(strData,'-',straData);
   for (int i=0; i<iNumData; i++)
   {
      int iPosOfColon = StringFind(straData[i],":",0);
      GlobalVariableSet(StringSubstr(straData[i],0,iPosOfColon),StringToDouble(StringSubstr(straData[i],iPosOfColon+1)));
   }
 
Seng Joo Thio:

Try this:

Why max 51 ?

why max 51 ?

 
Hadi Ein Jafari:

why max 51 ?


Try this.

#property strict

void OnStart()
{
    string inputFile = "splitData.txt";
    int h = FileOpen(inputFile, FILE_READ|FILE_TXT|FILE_ANSI|FILE_COMMON);

    if(h == INVALID_HANDLE) 
    {
        Print("Invalid handle");
        return;
    }

    string strData = FileReadString(h);
    
    // See # of characters
    Print(StringLen(strData));
    
    string arrPairs[];

    // Split on -
    int iNumData = StringSplit(strData,'-',arrPairs);
    Print(iNumData);
    
    // Loop over each pair and split on ':'
    string arrValues[];
    for (int i=0; i<iNumData; i++)
    {
        StringSplit(arrPairs[i],':',arrValues);
        PrintFormat("i [%d] Pair was split: %s => %s", i, arrValues[0], arrValues[1]);
        GlobalVariableSet(arrValues[0],StringToDouble(arrValues[1]));
    }

    FileClose(h);
}

Global Vars

Files:
splitData.txt  21 kb
 
Hadi Ein Jafari:

why max 51 ?

These printouts were added by you, so I wouldn't know unless you show me your code, right? 

 
Seng Joo Thio:

These printouts were added by you, so I wouldn't know unless you show me your code, right? 

 
Hadi Ein Jafari:

Ok, you also printed iNumData, is that value correct?

If it's more than 51, then the exact strData that this code uses might contain unusual content... because if it's the same as the one you included in your first post, I have no problem creating 1024 global variables for it.

 
Anthony Garot:


Try this.


realy i dont know what is problem 

 
Hadi Ein Jafari:

realy i dont know what is problem 

 @Seng Joo Thio and my code are essentially equivalent, so the problem isn't there.

You need to look at the contents of the variable "Variable" when it comes back from the database. Something unexpected is coming through from your data stream, or the data stream is truncated.

 
Anthony Garot:

 @Seng Joo Thio and my code are essentially equivalent, so the problem isn't there.

You need to look at the contents of the variable "Variable" when it comes back from the database. Something unexpected is coming through from your data stream, or the data stream is truncated.

Problem is on receiving data.
please check it for me 

Special tnx.


//+------------------------------------------------------------------+
//|                                                 Slave_String.mq4 |
//|                        Copyright 2018, MetaQuotes Software Corp. |
//|                                             https://www.mql5.com |
//+------------------------------------------------------------------+
#property copyright "Copyright 2018, MetaQuotes Software Corp."
#property link      "https://www.mql5.com"
#property version   "1.00"
#property strict

//=================================================MySQL===============================================================>*/-2019/01/16
#include <MQLMySQL.mqh>
//#include <JAson.mqh>
string Host,User,Password,Database,Socket; // database credentials
int Port,ClientFlag;
int DB; // database identifier
input string dbusername="wiki";  // Username
input string dbpassword="wiki";  // Password
bool Protection=false;
string QuerySELECT4variable;

//------------------------------------------------------------------
string STR_DR="DR";
string STR_DR_Symbol="DR"+Symbol();

//-----------------------------------------------------------------
//=================================================MySQL===============================================================>*/


string hadi;
//+------------------------------------------------------------------+
//| Expert initialization function                                   |
//+------------------------------------------------------------------+
int OnInit()
  {
   Void_STR_DR_Symbol_Checker();
   Void_DR_Creator();
   if(GlobalVariablesTotal()<=2)
     {
      Void_datareceiver();
     }
   return(INIT_SUCCEEDED);
  }
//+------------------------------------------------------------------+
//| Expert deinitialization function                                 |
//+------------------------------------------------------------------+
void OnDeinit(const int reason)
  {
//---
  }
//+------------------------------------------------------------------+
//| Expert tick function                                             |
//+------------------------------------------------------------------+
void OnTick()
  {
//---

  }
//+------------------------------------------------------------------+


//▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲*/
//≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡>
void Void_STR_DR_Symbol_Checker()
  {
   if(StringSubstr(STR_DR_Symbol,2,StringLen(STR_DR_Symbol))==Symbol() && GlobalVariableGet(STR_DR_Symbol)==1234.1)
     {
      Comment(StringSubstr(STR_DR_Symbol,2,StringLen(STR_DR_Symbol))," is data receiver !");
     }
  }
//▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲
//≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡>
void Void_DR_Creator()
  {
   if(GlobalVariableCheck(STR_DR)==false)
     {
      GlobalVariableSet(STR_DR,1);
      GlobalVariableSet(STR_DR_Symbol,1234.1);
      //Print("1 ; STR_DR_Symbol Created");
     }
  }
//▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲
//≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡Void_datareceiver≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡>*/
void Void_datareceiver()
  {
   if(StringSubstr(STR_DR_Symbol,2,StringLen(STR_DR_Symbol))==Symbol() && GlobalVariableGet(STR_DR_Symbol)==1234.1)
     {
      DB=MySqlConnect("mysql6002.site4now.net","a29b68_expert","Asd!@#1azza1","db_a29b68_expert",3306,(string)0,0);
      if(DB==-1)
        {
         Comment("Connection failed! Error: "+MySqlErrorDescription,'\n');
        }
      else
        {
         Comment("Connected! DBID#",DB,'\n');
        }
      //string QuerySELECT4variable="SELECT variable FROM stringvariables WHERE id="+"\""+"1"+"\""+""; //~~~~~~~~~
      QuerySELECT4variable="SELECT variable FROM stringvariables WHERE id=1"; //~~~~~~~~~
      //string QuerySELECT4variable="SELECT * FROM stringvariables WHERE id=1"; //~~~~~~~~~
      int Cursor4variable=MySqlCursorOpen(DB,QuerySELECT4variable); //~~~~~~~~~
      Print("Cursor4variable : ",Cursor4variable);
      int Rows4variable=MySqlCursorRows(Cursor4variable); //~~~~~~~~~
      Print("Rows4variable : ",Rows4variable);
      string Variable; //~~~~~~~~~

      //------------------------------------------------------------------------------*/
      if(MySqlCursorFetchRow(Cursor4variable))
        {
         Variable=MySqlGetFieldAsString(Cursor4variable,0);
         Print(Variable);
         //------------------------------------------------------------------------------*/
         string strData = Variable;
         // See # of characters
         Print(StringLen(strData));
         string arrPairs[];
         // Split on -
         int iNumData = StringSplit(strData,'-',arrPairs);
         Print("iNumData",iNumData);
         // Loop over each pair and split on ':'
         string arrValues[];
         for(int i=0; i<iNumData; i++)
           {
            StringSplit(arrPairs[i],':',arrValues);
            PrintFormat("i [%d] Pair was split: %s => %s", i, arrValues[0], arrValues[1]);
            GlobalVariableSet(arrValues[0],StringToDouble(arrValues[1]));
           }
         //---------------------------------------------------------------------------------*/

      MySqlCursorClose(Cursor4variable);
      Variable="";
      if(StringSubstr(STR_DR_Symbol,2,StringLen(STR_DR_Symbol))==Symbol() && GlobalVariableGet(STR_DR_Symbol)==1234.1)
        {
         Comment(StringSubstr(STR_DR_Symbol,2,StringLen(STR_DR_Symbol))," is data receiver !");
        }
      MySqlDisconnect(DB);
     }
  }
//▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲


 
Hadi Ein Jafari:

Problem is on receiving data.
please check it for me 

Special tnx.

Can you show us the log?

Reason: