I mis-typed! Sequence HHMMSS.SSS or HHMMSS.SSS ? Albert > On Jun 3, 2017, at 2:10 PM, Bruce Chitiea <rby...@safesectors.com> wrote: > > 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" <alb...@albertberry.com <mailto:alb...@albertberry.com>> > To: "rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>" > <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>> > 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 <rby...@safesectors.com >> <mailto:rby...@safesectors.com>> 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" <rby...@safesectors.com >> <mailto:rby...@safesectors.com>> >> To: "rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>" >> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>> >> 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 rbase-l+unsubscr...@googlegroups.com >> <mailto:rbase-l+unsubscr...@googlegroups.com>. >> 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 rbase-l+unsubscr...@googlegroups.com > <mailto:rbase-l+unsubscr...@googlegroups.com>. > 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 rbase-l+unsubscr...@googlegroups.com > <mailto:rbase-l+unsubscr...@googlegroups.com>. > 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
