THEMA: 1. Bedingte Verarbeitung 2. Assoziative Stringersetzung

' VB.NET Script Beispiel
Public Function DoWork() As Object

  Dim sArtNr as String
  Dim sRet as String
  Dim sBedingung1 as String
  Dim sBedingung2 as String

  sArtNr = InValues(0).GetString()
  If sArtNr is Nothing Then sArtNr = ""

  sBedingung1 = InValues(1).GetString()
  If sBedingung1 is Nothing Then sBedingung1 = ""

  sBedingung2 = InValues(2).GetString()
  If sBedingung2 is Nothing Then sBedingung2 = ""

  If sBedingung1 = "G" Then
    sRet = sArtNr + " G Fall"
  Else If sBedingung2 = "Q" Then
    sRet = sArtNr + " Q Fall"
  Else
    sRet = sArtNr
  End If
	
  DoWork = sRet

End Function

// Beispiel Skript in C#

// globales String Array
string [] lines = null;

public object DoWork()
{
  string sRet = String.Empty;

  string sCompare = (string)InValues[0].GetString();
  if (sCompare == null)
    sCompare = String.Empty;

  sCompare = sCompare.ToUpper().Trim();

  // ersetzen Liste nur einmalig einlesen
  if (lines == null)
  lines = File.ReadAllLines("ersetzen.txt");

  if (lines != null)
  {
    foreach (string line in lines)
    {
      // CSV Datei 1. Feld = Wert der geucht wird, 2. Feld = Rückgabe bei match
      char[] split = { ';' };
      string[] sTemp = line.Split(split);
      if (sTemp[0].ToUpper().Trim() == sCompare)
      {
        sRet = sTemp[1];
        break;
      }
    }
  }
  else
  {
    // nicht gefunden!
    sRet = (string)InValues[0].GetString();
  }

  return sRet;
}