Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Text file export- Remove white spaces after each field

  1. #1
    Join Date
    Nov 2015
    Posts
    2

    Default Text file export- Remove white spaces after each field

    I used the pentaho data integration tool to export some data in a text format. However, after each field it adds an extra white space. I used the fixed column length and in case of strings, I want the column to have white space if the entire length of the column is not used, but the export file also has an extra space after that.
    if i have 2 fields 123 and abc both with length= 3
    i want it to appear as 123abc
    but what i get is 123 abc
    so, i get an extra white space between 2 fields.

    I have set the column delimiter to blank as well. Is there a way to fix this? please help!!

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

    Default

    As far as I know, if you export using Fixed file format it should work as you want.
    I have set the column delimiter to blank as well
    Fixed file format should not have any delimiter.
    -- Mick --

  3. #3
    Join Date
    Nov 2015
    Posts
    2

    Default

    I have tried that but still not working.

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

    Default

    Quote Originally Posted by prakash551 View Post
    if i have 2 fields 123 and abc both with length= 3 i want it to appear as 123abc but what i get is 123 abc so, i get an extra white space between 2 fields.
    See, basically you told us you were trying something and it turned out no good.
    If you really need help, attach the smallest transformation still able to show your problem - a Data-Grid and a Text-File-Output in your case, I presume.
    Make it able to run on any machine - by avoiding local file pathes - and you might get helpful advice in next to no time.
    Or wait for someone that can remember making exactly the same mistakes as you.
    So long, and thanks for all the fish.

  5. #5

    Default

    Just add a Javascript step and concatenate the 2 fields in question.

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.