PDA

View Full Version : How to convert str to elapsed time ?



Penalva
05-03-2007, 09:04 AM
Hello,

in a log file i've a string like that :
1:10:23:14.032 (1 day, 10 hours ...).

I've tried to convert to a date, but it's not a date. If i want to keep this value in a table (in second for example), how can i convert this string to a value in seconds.
This string can change from line to line to line (sometime there's 0.00, sometime 23:45.1, sometime 16:45:30 ...).

Penalva
05-04-2007, 04:59 AM
I think it's not possible to use Pentaho Data Integration, i can't read text file, i can't convert/read numbers !!! I've lot of errors and there's not a lot of documentation on PDI. After three days on a single file, i stop.