Albert:
Thanks, yes.
Tried several TIME FORMATS, producing for all records (examples):
1. HH:MM:SS.SSS > 16:30:45.000
2. HH:MM:SS.sss > 16:30:45.45
3. HH:MM:SS.000 > 16:30:45.000
4. HH:MM:SS.TTT > (No Import)
5. HH:MM:SS.123 > 16:30:45.123
6. HH:MM:SS. > 16:30:45.
Missing something, certainly.
Any thoughts appreciated.
Bruce
------ Original Message ------
Sent: 6/3/2017 12:59:47 PM
Subject: Re: [RBASE-L] - Re: Importing Time Values: HH:MM:SS.SSS
From: "Albert Berry" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
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]>
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.
--
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.
--
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.
