Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Using multiple characters in enclosure on csv input

  1. #1
    Join Date
    Apr 2013
    Posts
    3

    Default Using multiple characters in enclosure on csv input

    hi ,

    in csv input step ,can we set multiple characters in enclosure ?e.g. &| two characters.if i use only one character ,it's fine.

    when i look for the document of enclosure. it said $[6F,FF,00,1F] ,is it mean there are four characters in the enclosure , like oÿnulus ?

    when i use &| the value in field is cutting like |test& ,leaving | in the header, & in the footer. if i use variable in the enclosure ,it did the same .

    can anybody help me ..
    tks

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

    Default

    We can't use different (opening and closing) characters for enclosure with a CSV Input step.
    You will have to use custom logic (scripting, regular expressions, ...) to extract fields from such input.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Apr 2013
    Posts
    3

    Default

    Quote Originally Posted by marabu View Post
    We can't use different (opening and closing) characters for enclosure with a CSV Input step.
    You will have to use custom logic (scripting, regular expressions, ...) to extract fields from such input.
    thank marabu!
    until now i know that why i can't get the right result .

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.