Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Double delimiters and enclosures

  1. #1
    Join Date
    Sep 2010
    Posts
    100

    Default Double delimiters and enclosures

    Hi, I'm trying to read a text file with columns separated by a double character ith the csv file input step. It looks like this step could use double delimiters and enclosures but, the problem is kettle shows the second character from the delimiters or enclosures.

    for example: the text file has: ""hello"";""bye""

    the result string is:
    column1: "hello""
    column2: "bye""

    Note the first delimiter before the text and the double delimiter after it. Any solution for that? thanks a lot

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

    Default

    Search and replace quotes?
    You can use the Replace in String step.

    Mick

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.