Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Extracting Values from Text Input Filename

  1. #1

    Default Extracting Values from Text Input Filename

    Hello,


    Believe it or not, I need to extract and parse the filename from the text input files and use that as a value for each row to insert. We receive many files, whose names are significant.



    I know how we can load multiple files using regular expressions, which is very helpful. Now, how to parse each file name and make it available as a Constant (for instance)?



    Thanks very much!
    Seth

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

    Default RE: Extracting Values from Text Input Filename

    In the "Content" tab, check "Include filename in output" and specify the fieldname for the field that will contain the filename.

    HTH,
    Matt

  3. #3

    Default RE: Extracting Values from Text Input Filename

    Great, thanks!

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.