Definitely an off the wall idea, but have you tried setting the sequence to HH:MM:SS.SSS or HH:MM:SSSSS ? Albert > On Jun 3, 2017, at 12:01 PM, Bruce Chitiea <[email protected]> wrote: > > Progress: > > Placing the "BROWSE * FROM TimeImportTest" line immediately after the import > code (before re-setting the Time Format *doh* ) produces the desired time > FORMAT but drops the thousandths values during the import > Example: > > Excel: 16:30:45.321 > > Imports as: 16:30:45.000 > > Clues? > > Bruce Chitiea > SafeSectors, Inc. > 909.238.9012 Mobile > > > ------ Original Message ------ > Sent: 6/2/2017 4:16:27 PM > Subject: Importing Time Values: HH:MM:SS.SSS > From: "Bruce Chitiea" <[email protected] <mailto:[email protected]>> > To: "[email protected] <mailto:[email protected]>" > <[email protected] <mailto:[email protected]>> > Cc: > > All: > > RBGXE Latest: > > I need to import Time values > > ... from Excel format: hh:mm:ss.000 > ... to R:BASE format: HH:MM:SS.SSS > > Best import result I get in R:BASE is: HH:MM:SS > > So I'm missing a step. How do I import those thousandsss? > > Thanks much, > Bruce > > > My test code: > > SET TIME SEQUENCE HHMMSS > SET TIME FORMAT HH:MM:SS.SSS > > DELETE ROWS FROM TimeImportTest > > GATEWAY IMPORT XLS TimeImportTest.xlsx + > APPEND TimeImportTest + > OPTION FIRST_ROW 2 + > |ADD_MAPPING TimeImportID = A + > |ADD_MAPPING TimeImportTestValue = B > > SET TIME SEQUENCE HHMMSS > SET TIME FORMAT HH:MM:SS > > BROWSE * FROM TimeImportTest > > RETURN > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>.
-- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
