Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Number is coming with comma's and enclosed in double Quotes

  1. #1
    Join Date
    Jul 2015
    Posts
    1

    Default Number is coming with comma's and enclosed in double Quotes

    Hi

    I am getting data to data injector as follows
    name,address,"6,500.69","-7,500.89",-----

    I would like to split the data as follows

    name
    address
    6500.69
    -7,500.89
    -----
    -----

    I am newbie to pdi. Please let me know how can i achieve this in kettle.

    Thanks & Regards,
    Rao.

  2. #2

    Default

    Rao, you should:
    1 - create a new transformations
    2 - add a "text file input" step
    3 - Once you add the step, open the sptep properties by double clikc on it.
    4 - go to the second tab "Content" and change separator from ";" to ',"

    that should give you a good start.

    Hugo

Tags for this Thread

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.