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]>
To: "[email protected]" <[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].
For more options, visit https://groups.google.com/d/optout.
