Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Can't read in Excel or Text File Inputs

  1. #1
    Join Date
    Mar 2006
    Posts
    16

    Default

    abc
    Last edited by stu_purvis; 02-01-2010 at 02:22 PM. Reason: solved

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Can't read in Excel or Text File Inputs

    Hi Stu,

    Try the "Add" button to add files to the list of "selected files".
    Please google on the internet for "regular expressions".
    I know that a REGEXP are not the most intuitive thing around, however, it's very powerfull.
    In case you all wonder, I'm building a wizard to enter REGEXPs.

    All the best,

    Matt

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Can't read in Excel or Text File Inputs

    . any character
    * repeated 1 or more times
    ^ beginning of line
    $ end of line

    Expression example: .*txt$
    Means: all files ending with txt

    Again: try google, play with it.

    Matt

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Can't read in Excel or Text File Inputs

    Hi Stu,

    Enter a filename ("File or directory) and and a wildcard ("regular expression") and click the "Add" button.

    This will add the directory and wildcard into "Selected Files" grid.

    BTW, it does NOT make sense to add a wildcard to a filename. There would be absolutely no point to it would it?

    To edit the file/directory/wildcard, select the line in the grid and click on the "Edit" button.

    ...

    OK, I get it, you're pulling my leg are you ;-)

    Cheers,
    Matt

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Can't read in Excel or Text File Inputs

    Stu,

    Glad to hear it. The REGEXP wizard will take the sting out of most of the issues you had.
    I'll try to get it into the 2.3.0 release next month.

    All the best,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.