Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Problem in splitting date string to Day, Month, Year

  1. #1

    Question Problem in splitting date string to Day, Month, Year

    Hi I am new to Pentaho data integration & spoon and am trying to split a date string already converted to 'dd-MM-yyyy' format with 'Select Value' to Day, Month and Year with 'Split fields'. The problem is if I set the delimiter as "-" or - and type of each field as 'number' the debugger throw up an error ('non-numeric value at position 3'. If I set the type of each field as 'integer' then Split Fileds only returns the values for Day correctly while Month and Year columns show up as null. Any help appreciated. Thanks

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

    Default

    No need to convert a Date field to a String field to extract parts.
    Look at the Calculator step for functions to extract Day of Month, Month of Year, and Year.
    So long, and thanks for all the fish.

  3. #3

    Default

    Thanks for that!

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.