Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Table output adding a space on string insert '-1'

  1. #1
    Join Date
    Jun 2009
    Posts
    23

    Default Table output adding a space on string insert '-1'

    Not an issue, user error.
    Last edited by dunleav1; 06-26-2009 at 08:55 AM. Reason: Found issue.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Number to String conversions can be steered by providing specific conversion masks in the "Select Values" step (for example).
    The numeric value minus one can be formatted for example like this (without the double quotes) :

    • "#;-#" gives "-1"
    • "000;-00" gives "-01"
    • " #; -#" gives " -1"
    • " '['#']';'['-#']'" gives "[-1]"
    • etc

    HTH,
    Matt

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.