Package - Variable Read from CSV+Email

The answer was already provided

www.etl-tools.com/forum/advanced-etl-pro...v-file.html?start=24

You can loop over lines with in the file using loop action (Loaded for the file option)

www.etl-tools.com/wiki/advanced-etl-proc...actions/loop-action/

The problem is that loop assigns data to a single variable per line. (<Loop Value>

In your case every line in the file contains multiple variables,
since you do no not want to load data into the database you have write a script which will split <Loop Value> into multiple variables

We will create an example for you

Here it is





var s: string;
    s1: string;
    s2: string;
    s3: string;
    i: Integer;
begin
  s:=GetVariable('<Loop Value>');
  i := Pos(',',s);
  if i>-1 then
   begin
    s1:=Copy(s,0,i-1);
    s:=Copy(s,i+1,1000);
   end;
   SetVariable('<Variable1>',s1);

  i := Pos(',',s);
  if i>-1 then
   begin
    s2:=Copy(s,0,i-1);
    s:=Copy(s,i+1,1000);
   end;
   SetVariable('<Variable2>',s2);
   SetVariable('<Variable3>',s);
   Result := true;
end ;

Please see attached file

For Forum users reading this, Team ETl-tools have released a swanky new feature which makes this very simple

www.etl-tools.com/wiki/advanced-etl-proc...actions/loop-action/


See my rudimentary explanation to supplement . As you see I didn't use any special codes <> but everything works fine