Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Text File Output format field question

  1. #1
    Join Date
    Sep 2013
    Posts
    235

    Question Text File Output format field question

    Hi all.

    I have simple text file output example.
    Can please someone explain me how does Length/Precision/Currency/Decimal/Group settings can communicate with each other?
    I don't want to use 'Format' field - just using other to check it is works properly.

    Just for testing purposes I have input as a BigDecimal like

    1300025525.002356898

    ...and for file output step I want to see what happens if:

    this is file output settings
    Name:  fileOutSettings.jpg
Views: 37
Size:  12.2 KB

    this is file output
    Name:  fileOut.jpg
Views: 37
Size:  16.5 KB

    So questions:
    1) Why is $ is not shown?
    2) Why grouping symbol not shown?
    3) Why decimal is truncated to one symbol?
    4) Is Length is taken into account?

    Once again this is only test-functionality example - to see how this field output settings can communicate each other.

    Thank you in advance.

    This is simple transformation.
    fileOutput.ktr

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    1) Your are not specifying a 'Format' string so no currency formatting will be inserted.
    2) The 'Group' symbol should be either a '.' or a ',' but you are not providing a 'Format' string so apparently the default format string doesn't call for grouping.
    3) The 'Decimal' symbol should really be either a '.' or a ',' but apparently no more than one character.
    4) The string length apparently overflows by default when the formatted number is longer than the specified 'Length'.

    You really need to provide a format string in order to make the formatting work as desired. Some additional information on formatting decimals and currency can be found here: http://docs.oracle.com/javase/7/docs...malFormat.html
    Last edited by darrell.nelson; 04-21-2014 at 01:03 PM.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

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.