Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Reading from txt file.

  1. #1
    Join Date
    Aug 2013
    Posts
    16

    Default Reading from txt file.

    Hello all,
    I am having some issue reading from a specific txt file. The delimiter being used is "|" however I am not sure how to pull the field names then begin to pull the lines of data. Would it be more beneficial to use a step other than a "text file input" step?

    There are 30 fields names that I am trying to pull however I am having issues trying to extract the field names and the results as well. I may be complicating this more than it should be...

    Any and all help is very much appreciated. Thank you so much!

    sample.txt

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Your sample file is a report file with fixed width columns.
    Due to the first line being empty, Text File Input can't read the field names.
    If you want to read the header line using action "Get Fields" you must store the header line in a scratch file and read from there.
    No problem to exchange the filenames later.
    So long, and thanks for all the fish.

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.