TOPIC: 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();
}