Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Padding an empty string

  1. #1
    Join Date
    Nov 2016
    Posts
    2

    Default Padding an empty string

    How can i pad empty fields?
    String Operations Pad works on null fields or on fields with one space, but not on empty fields... Or am i missing something?

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

    Default

    Kettle treats empty String fields as null by default.
    You can control this behavior through Kettle property KETTLE_EMPTY_STRING_DIFFERS_FROM_NULL.
    Look for it in theSpoon Edit menu.

    With String-Operations you can pad a non-empty field.
    Use step If-Field-Value-Is-Null for null fields (or empty strings).
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Nov 2016
    Posts
    2

    Default

    Quote Originally Posted by marabu View Post
    Kettle treats empty String fields as null by default.
    You can control this behavior through Kettle property KETTLE_EMPTY_STRING_DIFFERS_FROM_NULL.
    Look for it in theSpoon Edit menu.

    With String-Operations you can pad a non-empty field.
    Use step If-Field-Value-Is-Null for null fields (or empty strings).
    It works, thank you very much.

    Can i change the variable at job start up?

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.