You are welcome! Sometimes off the wall is the only solution. Glad I could help.
Albert > On Jun 13, 2017, at 7:43 AM, Bruce Chitiea <[email protected]> wrote: > > All: > > Credit to Albert Berry last weekend for the clue: "... how about importing > text?" > > Forget about importing from the [hh:mm:ss.000] formatted data input column > ("B", below). Not prudent, won't work. > > Create an Export Column ("C", below) with Data Type [General], with the TEXT > function: > > A B C > TimeID INPUTColumn EXPORTColumn > ------ ------------ ------------------------ > 1 1001 12:45:30.987 =TEXT(B1,"hh:mm:ss.000") > > Import to R:BASE from ExportColumn "C". Works flawlessly with both the FILE > GATEWAY and the GATEWAY IMPORT XLS command. > > Thanks for your patience. > > Bruce Chitiea > SafeSectors, Inc. > 909.238.9012 Mobile > > -- > 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.
