Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: String to date convertion

  1. #1

    Default String to date convertion

    I am trying to convert the string 24/01/00 (format dd/mm/yy) to date, using the format d/M/yy and I am getting a message error (see attachment).

    To me, this date is correct. What should I do?

    Thanks for help

    Osmar Mateus
    Attached Images Attached Images

  2. #2

    Default

    I have attached a sample w/different formats if that works

    regards, Charu
    Attached Files Attached Files
    Last edited by charusheel; 03-14-2011 at 11:35 AM.

  3. #3
    Join Date
    Mar 2008
    Posts
    140

    Default

    Looking at the attached PDF I am noticing that the date it is having a problem with does not have a year at all. It appears as '24/1/'. Is it appearing that way in your data or is the string being truncated somewhere?

  4. #4

    Default

    cboyden

    You are correct, but in the csv input file the date is 24/01/00 (obviously refers to year 2000); in the parsing the year 00 is converted to blanks.

    Thanks

    Osmar Mateus

  5. #5

    Default

    charusheel

    I am using the format that you adopted in the field today4. The problem only hapens when the year, in the input file, is 00 (year 2000).

    Thanks

    Osmar Mateus

  6. #6

    Default

    You are right. I modified transformation and specified the input format both for CSV file and Select values steps.

    That solves the problem. But I agree that is is a defect.

    see attached files:. Please modify the extension to .csv and modify CSV step to point to the file.
    Attached Files Attached Files

  7. #7

    Default

    charushell

    Thanks for your help!

    Osmar Mateus

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.