Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Enclosure and quotes

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Enclosure and quotes

    Hello everyone,

    I have text file with tab as a separator and where text fields are enclosed in quotes. It looks like PDI consider quotes as separator as well (slightly different). For example if I have fields with quotes inside is will read only up to second quotation mark i.e. "Example with "quotes" inside". PDI will read only "Example with ". I attached an example. Does anybody know how to make PDI read it all until next tab?

    Regards,
    Alex

    P.S. I know workaround. I can use CSV as input, but still wonder why text input behaves this way
    Attached Files Attached Files
    Last edited by august_month; 12-08-2011 at 06:00 PM.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi Alex.
    If you remove the "encloser" option, it should read the sentence:
    Example with "quotes" inside
    in one single field.

    In your example, I would search for quote-tab-quote and replace it with tab.
    This should keep your quotes inside each field.
    Then you can read the file deleting the "encloser" option.

    Mick

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you, Mick!
    I will try it. However, I am surprised that CSV input behaves differently from Text input. Seems like a bug.

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.