Import Bundle Items

// you may change here the bundle file name and the delimiter string bundlefile = "bundles.txt"; char [] delimiter = { ',' }; public object DoWork() { if (InValues.Length < 2) throw new Exception("min. 2 input parameter expected!"); // read all lines from the bundle file string [] lines = File.ReadAllLines(bundlefile); // get current group out position (AutoID Heater) int pos = (int)InValues[0].GetInt(); // get current item string item = (string)InValues[1].GetString(); // in case a third parameter is valid get the quantity int qty = -1; if (InValues.Length > 2) qty = (int)InValues[2].GetInt(); // loop over all lines an search for a bundle article foreach (string line in lines) { // split the line and compare the item number string [] columns = line.Split(delimiter); if (item.CompareTo(columns[0]) == 0) { // bundle article found if (qty < 0) return columns[pos * 2]; else return Convert.ToInt32(columns[1 + pos * 2]) * qty; } } // in case no bundle article return the original values if (qty < 0) return InValues[1].GetValue(); else return InValues[2].GetValue(); }