Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Formatting characters in file output

  1. #1
    Join Date
    Jun 2007
    Posts
    138

    Default Formatting characters in file output

    In the File ouput step,
    I m having some field as String,which is 10 characters in length.
    For an instance it gets value
    '1'
    But I want formatting like it sholud be,
    ' 1'

    Like all remaing characters should be repalced by white space,into right..

    What to choose in "format" tab of it?

    '##########'
    is not working.

    Plz guide me..
    Regards,
    kedar.mehta@tcs.com ,
    Tata consultancies Ltd

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Lol ... some people want black, some people want white. Your one of the exceptions that wants a space before positive integers

    Removing the format altogether should do the trick.

    Regards,
    Sven

  3. #3
    Join Date
    Jun 2007
    Posts
    138

    Default Ellaborate more

    I want white!! The colour of Peace!!

    Actually,Plz dont bother abouth the data,it can have '1' or 'c1' or 'cc' ..in short it is some Character .Treat the 1 as character n padd white space with right aligned data.

    I cudnt get u,Shall i remove all format?how it will help?!!

    Plz put some light on that..
    Regards,
    kedar.mehta@tcs.com ,
    Tata consultancies Ltd

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.