O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – reading all your files at a time using a single text file input step and regular expressions

You can do the same thing that you did previously by using a different notation. Follow these instructions:

  1. Open the transformation that reads several files and double-click on the Input step.
  2. Delete the lines with the names of the files.
  3. In the first row of the grid, under the File/Directory column, type the full path of the input folder, for example C:\pdi_files\input.
  4. Under the Wildcard (RegExp) column type (usa|europe)_[0-9]{6}\.txt.
  5. Click on the Show filename(s)... button. You will see the list of files that match the expression:
    Time for action – reading all your files at a time using a single text file input step and regular expressions
  6. Close the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required